I found this quote at http://www.mcse.ms/archive85-2004-2-364893.html

Steve 2004-02-06, 11:33 am

Update on this. I have turned...

The server group Server Administrators allows access to sqlagent jobs, but also allows other options.  In order to have them have dbo owhership for the objects they create you should...

This may be related to the latest McAffee Upgrade we did from 7.1 to 8.0i.

I have not verified the backup.  Currently we are using another solution to get backups completed successfully. 

There are no errors in the Event Logs other than the failure due to OS Error 87.  IT is interesting that in the other location where we are using this...

I had never heard of it bu tyou could check out hte Gupta web site http://www.guptaworldwide.com.  It looks like it is used similar to how MS would like to...

I don't think users are getting any page timeouts.  THere are a couple of ways to see what is causing the lock timeouts:

1. If you get lucky you can see a...

YOu should use a locking hint to hold an exclusive lock on the row until your transaction completes. 

Select a from tableA with(updlock)

See BOL under Query Hints.

The question is what could be the problem.  The way the question is worded the only answer that is guaranteed to be wrong is answer D the msdb database cannot...

There is an executable that you need to run that is included with RS.  IT is called rsactivate.exe you can find out how to use it in the RS BOL.

I checked the route using the tracert utility.  The servers I am acking up across are onteh same switch so there are no hops between them.   I don't think there...

SQLBill,

I had not thought of any network timeouts so I'lll check on that, although, as I said this was working up to Monday night and these databases have not grown...

Prior to the restore you could script the users and permissions on the database.  Then after the restore run a script that removes all DB Users then run the script...

IT would not be difficult to use SQL-DMO to iterate throught each of the instances and run sp_who  or sp_who2 then display ther results on a web page or in...

That could be 2 issues:

1. The users need rights to the data source and do not have it.
2. You are using Integrated Security for the database connection and the user does not...