Hi,

DO you have the different types of Isolation Levels in SQL 2 K like 2005 ? I was not aware. I will try to do some reading on that. This...

Hi,

The deadlocking is due to the application being designed around a single table and there are hundreds of connections to it. I tried giving the reporting guys a different box...

I did not say DELETE log file. What i said was to have that removed from the list of files when you attach it. You have to have a shutdown...

When you attach the .MDF file back at the destination, you can manually remove the log file from the list and after attaching put the DB in FUll Mode and...

Hi,

Yes the disks are constantly hitting 100 mark. But then why it happens only in some databases ? I can run the UPDATE on another database on the same box...

Hi,

Its got 8 GB RAM, 8 Processors running SQL 9.00.3042.00 (SQL 2005 SP2). Cant detect any deadlocks just normal row locks. Checked locks configuration, memory config. All set to AUTO.