I have just installed SQL Server 2000 SP3 and am getting the following error when manually running a DTS package from the server : "xpsql.cpp: Error 87 from GetProxyAccount on line 604" All the stored procedures which are called from the DTS package run fine when I run them separately. Most of them make use […]
2004-01-15
1 reads
2004-01-14
1 reads
I am trying the Walkthrough - Creating a Data-Driven Subscription. The email formatted as HTML comes through OK but the emails with the PDF and Image attachments produce an email with the following error.The Microsoft Exchange Server received an Internet message that could not be processed. To view the original message content, open the attached […]
2004-01-14
2 reads
Hey Frank! I use VSS Too... I also do all of my TSQL work on Stored Procedures through a database project in Visual Studio. I like to use a lot of macros and columnar editing and QA doesn't provide either. So I do most of my work in Visual Studio. Plus since I use a […]
2004-01-11
Joseph gathered together some various bits of code and came up with a solution that lets you do RC4 encryption via the sp_oa~ procedures.
2004-01-09
8,853 reads
I actually kill two birds with one stone. Monitor the size of the backups and trend that. Allows me a verification that the backup completed. And I can see if things are growing. The raw space is less important to me than the data size.
2004-01-08
It's configure to monitor all servers in a domain that match a criteria such as: (AttributeValue(SQL Server 2000)) In this way, all the SQL servers will have an agent install to communicate with the MOM server for notification. So both the passive and active node will have this agent running and the passive is reporting […]
2004-01-06
1 reads
We're working on the text box bug. The notification idea is added to the list, will be a few days.
2004-01-06
I need system information of the client machine talking to Sql server database in a trigger. ie. Host name, Ip Address , the system login name.I get this info in Oracle using sys_context function that fetched from userenv. Is it possible to get this information in sql server as well.Any help is highly appreciated . Thanks […]
2004-01-05
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-05
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers