If people can post questions to a wide audience without bothering to test them you worry what state their database code must be in.

The database is in simple recovery so there are no log backups. I can run the query above every couple of seconds and the amount of space used in all...

I didn't read beyond the CREATE PROCEDURE. It wasn't the first line of the batch so I assumed "procedure would not run" would be the answer.

A very similar script is in BOL if you look up CHAR.

You may want to consider differentiating between types of backups. You may have log backups running fine but no full backups taking place.

Also I would consider including databases which do...

Has anyone experience of using Lab Manager for multi-streamed development with different data recency requirements? That's a stumbling block we're trying to plan for in a planned implementation.

Let's say...

The easiest way is to make the disk "unavailble". I'd do this by denying the MSSQLServer login account read permission to the disk which stores the data file.

Hope that helps

Yes as mentioned, try to avoid believing that cursors are always bad. Sometimes their performance can be as good as, if not better than other approaches. However, when using them...

Was the spid running any extended stored procedures such as xp_Sendmail? If the external process has hung and SQL has lost concept of it's state (success/fail) then you can see...

I misunderstood part of this question

"You'd like to also have a server kept in the same room as your primary server to act...

If you run sp_helpdb does the compatibility_level always read 80?

If the vendor has come up with this as their technical solution I'd seriously worry about their technical aptitude!! Imagine what your backups and maintenance routines are going to be ...

meaning?

Likewise:

Where

Col1 = @Param1

and Col2 = COALESCE(@Param2, COl2)

and Col3 = COALESCE(@Param3, COl3)

etc etc