The only obvious thing that I have seen in the past is if the time on the server differs greatly from the time on a domain controller.

If you can, add the following trace flags to your SQL Server startup Parameters:

-T1204

-T3605

This way when a deadlock is encountered you will get 'extended' deadlock information logged to the...

An interesting topic. I do have some major issues though. Trust is something that should not even be described in this context for few very simple reasons. Professionalism, responsibility and...

My warmest to you and yours Bruce.

Sure, I have a BB for work. But for myself I just want a phone. At home it is just a plain old POTS line too !

Just call me Earl...

You mught want to try a drop'n'drag file copy of 1 Gb file(s) to see if you get the same error. We had a situation like this a while...

Yes, I pause and reread things. However I do not go out for a smoke every time other wise some days that would mean smoking 4 packs of cigarettes at...

SQLRecon does differentiate between MSDE and full SQL 2000 instances and between SQLEXPRESS and full SQL 2005 instances. As for scanning on the network, this tool is highly innocuous. I...

I have one word to say: SQLRecon - it makes SMS look like a toddler in the pros when doing a SQL Server Inventory.

A word of advise, you should be...

Jeff, the article is excellent ! (I have to look at the site to cast a vote - 5 stars in my book).

Steve, maybe we can put a 'How To'...

Developer access in production ...

NOT.

Terminal Services will do the trick. Be warned though it can get quite expensive for licensing if you have a large nuimber of users.

If you want to investigate your current...

Glad to be able to help.

Have a great day Jeff !

Jeff here is the link needed to help calm the 'Nervous Nellies'

http://support.microsoft.com/lifecycle/?p1=2852

Let me look for it. I actually got the information when we had a production outage on a SQL 2000 SP3a instance in August this year and was told by...