Actually, Steve based on BOL documentation you can, however I never figured out how to get it to work as you cannot use it in an assigment of value. MS...

Or to make things easiest and reuse code use the sp_MSForEachTable stored procedure, it will cursor thru all the user tables without you having to code for it. You just...

The best way I know of where possible is to create an Alert then the response should be set to execute a job. The job can then in turn either...

You really need to build a control system into your application and database to do this. There was a similar thread a while back and I meant to put out...

Can this machine see all IPX/SPX traffic or not? Could be the local SAP broadcasts do not have the servers listed. Make sure you can see other IPX/SPX type servers...

Are you runnign SP_DROPUSER while in the context of the database where this orphaned account is. In QA that database should be listed on the toolbar as the current selected.

"Don't...

To the best of my knowledge that is a no or at least right off I cannot find a way. However you might try creating a trace and using another...

Run SELECT @@VERSION and you will see output like this.

Microsoft SQL Server 2000 - 8.00.534 (Intel X86)

Nov 19 2001 13:23:50

Copyright (c) 1988-2000 Microsoft Corporation

Developer Edition on Windows...

I don't know of anything but if you have any Visual C++ developers there is a lot of information on reading the items in Event logs on MSDN. I have...

Have you tried reinstalling just the client components to see if corrects. If so and does not then the problem is with system dll's most likely that were change in...

Collaboration Data Objects check MSDN and here a link to an Intro http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexch55/html/msdn_introcdo.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Check the registered server in EM and see if you can see the master database. If not then delete the registration and reregister. Should correct the problem.

"Don't roll your eyes...

C++ is required it has a specifc type of entry point that allows communication to take place. It is not a COM dll like VB. I have not tried but...

That is extremely slow. I usually get 2000+ records (text at that) in a few seconds. I am on a 10 MB network and this is running from a third...

Please be carefull of duplicating posts. See replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6415&FORUM_ID=19&CAT_ID=3&Topic_Title=DTS%3A+Oracle+to+SQL+2000%2D%2DSpeed&Forum_Title=Data+Transformation+Services+%28DTS%29

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)