I've run into this error a number of times because I usually use a MSX server to keep track and schedule maintenance amongst multiple servers. The offending database(s) are always...

Thanks Ed ! Not a day goes by when I do not learn something new from this forum !!!

What about setting the execution context ?

e.g.

exec some_database_name..sp_some_stored_procedure

This implies 3 things. First you are using a stored procedure. Second, it must reside in the master database....

EdVassie is right again. Whilst I have always been lucky in a number of ways. Usually Hitachi or EMC SANs to work with and more importantly having reasonable and open...

I also experienced situation as well. A manual uninstallation and reboot fixed things for me.

What a pain it must be ... it sounds as if MS needs to improve a bit more in the installation/upgrade area since they have taken steps backward ...

I have not had an issue with spell check since the new web site was rolled out. I tried it the first day and have used it twice today. I...

on a slightly different note ... the sequence of events described here seems like a perfect justification for a test cluster - whether it be physical or virtual. 😀

Here's one better:

stdin std.err

Generalist to specialized generalist ... Mainframe, DEC/PDP, DEC/VAX, BSD Unix, Altair, PC's, Xenix, Client Server. This background has given me the foundations upon which to build my house. I also...

The ResKit Log Shipping of v7.0 was far simpler than the 69 (or was it 79) page "How To" guide that MS had for setting up an NT4.0 cluster for...

"SQL Server is better than Oracle"

"Why?"

"Because"

"Why Because?"

"Because it just is"

I would add trace flags -T1204 -T3605 to the SQL Server startup parameters. This way when deadlocks occur the relevant information is written out the the SQL Server errorlog. Granted,...

Two NICs (single network port on each) in each server may be the correct answer for the question but Three NICs (single network port on each) is probably the norm...

What ever happened to ISO 9001 ?

It seems to me that if that model were followed (and enhanced a bit) SOX would be easy. Oh, by the way my firm...