Adiga,

Thank you for your suggestion, but I resolved the problem before reading your post, so I didn't try it.

I resolved the issue by adding the Service Account to the Administrators...

no Henry, nothing on Apps logs or Systems log or event viewer

That's what so weird and challenging about this issue.

the Last thing that the system log records is that the SQL Agent entered stopped state.

The Application log shows that it stopped...

I guess we are missing main point of the blog, or I'm really wrong... it wouldn't be the first time I see things differently.

To me, the googleing and use and...

yeah, something broke.

I was really exited to visit the page using my Droid 1, but I guess we'll have to wait.

For me, in order to "fully understand" deadlock issues, you need to be able to reproduce one, see the output it generates, and resolve it.

Check out this article,

http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx?PageIndex=1

It...

Hi,

I actually worked on this issue for almost half a day and I couldn't resolve a snack with John's code a few days ago, and I just gave up. ...

There are many ways to skin a cat:

This is my way:

select crdate,[Name] from sys.sysdatabases where name = 'tempdb'

Why does this work?

Well... every time you MSSQL Starts, it recreates the TEMPDB.

Miguel

WOW, excellent script.

However, this only give you the information for a single instance.

These script could be modified to loop though all the instances.

My addition:

To get a list of the instances...

Interesting.

Really nice tip to use sp_helptext to find out how the SP is written. Thank you

I was able to isolate the piece of code that was causing the extra...

Thank you for your attention Lowell.

I am not running really a store procedure, but I'm having issues OUTPUTING the results of SP_HELPUSER to a table. Actually, just running the...