select @@version

Would return

Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows...

Try this http://www.awprofessional.com/articles/article.asp?p=599700&rl=1 

Was that a question?

Sorry yes of course, from there Bill can track back which is the offending process that's taking so long. There can be a...

What does dbcc opentran ("insertYourdbNameHere")  show you?

I understand that it worked previously. Look at the network card make sure you're not set to auto detect. Has anything changed on the network? New routers, switches,  etc... Try...

Does anyone of have a script to pull the users and passwords fromn a LDAP database?

appreciate the feedback, that was my guess as well. Wonder if their is anything inheritably wrong with running without updating one user database.

probably...

Limiting the transaction file growth will only cause the job that needs it to grow to fail. You need to let it auto grow and manage your transactions closely

Though...

You can always increase the size of TempDB but you should be asking why is it growing?

How big is TempDB and where is it currently stored, do you have...

Staci,

Silly question but did you look for any backups on disk?

Zach

Agree with David if its this small and only one table

In bad situations I've also handle it this way - bcp out the data that I can, restore the last...

Sean,

I absolutely agree with your comments; however the need for as many DBA at any given site can be and has drastically been reduced.

We have well over 130 database servers at my site and for 18...

of course not having your dataf iles on the shared resource might be one reason you can't join a cluster. Duh!!!!

Would have been nice to have had a window pop...

8.00.2039

Thanks,

Zach