Or use DMV's.

Gianluca

I have used the option u mentioned and it has worked for me when we used crystal reports. One point to note is the management of T-Logs. If the report...

To add to Jeffery's points

from BOL

However, transaction log files cannot be part of a filegroup; they are separate from one another. As the transaction log grows, the first log...

The options you mentioned are not clear.

DBCC CheckDB does not "fail"...

Paula

You need to look up BOL and try it yourself. Then if you come up with issues come back to us.

If you want to use variables that hold some part of the where clause you need to use dynamic queries.

A long shot...

Was your update query some mathematical updation like adding 10 yrs to a date column or something similar. In that case you can reverse it otherwise its just...

Hi Patrick

Can u identify the query that's causing this. Your query is using hashing and this is generally bad for performance. You will want to re-write this query in a...

Hi

You need to analyze the deadlock graph and see which process is causing the deadlock. You will be able to make out the stored procedure/query which is causing this. Once...

You could look at DDL triggers. They should be your second line of defense first is always giving proper permissions to users.

I agree. If you do not have disk space then backup to a tape.

Correct me if i have misunderstood the whole thing. What if you move the database files only to your new disks. You can use attach and detach for this....

The best way is to make sure that rights to the production database are given only to required users.

Hi

Use DBCC Traceon (1222, 3605, -1) for this. This will ouput the deadlock information to the error log. Analyzing the dead lock info so got is slightly complicated if...

Please post this in the SQL 2000 forum.