You can do this by copying the files like you did and then attaching them back to the server under a different name using the sp_attach_db stored procedure.

It would be...

Another option would be to trigger an alert, which in turn would start a job that truncates the table.

You would need to create a custom non-critical error message that logs...

This could very well be an indexing problem.

I worked with a clustered instance that had a similar issue: 8 CPUs maxing out, but memory and disk usage...

Are you using it on Windows 2000 or NT4?

On Windows 2000, you can do this by creating a Counters log which saves the output to a file.

JM

Hey Ludo,

The /3GB switch is all you need when your server has 4GB of RAM. Make sure that it is the Enterprise edition and not Standard. The standard...

Here is a way you could find out which views have the table in their definition across one server, assuming your haven't created the view WITH ENCRYPTION

sp_MSforeachdb @command1 = 'Print...

It simply means that the connection has set quoted identifier on.

Here is a link you can check out on Microsoft's Knowledge Base:

http://support.microsoft.com:80/support/kb/articles/Q243/3/52.asp&NoWebContent=1

You can set a trace flag at...