I need an up-to-date copy whenever..  Not necessary routinely, but every so often.  I do have down time.. 28 hours from Sat evening to Sun evening.

I like your idea of...

If I setup another warm-standby, I'm in the same boat.      To set that up, I would have to get a new copy of...

I'm seeming having a hard time describing what I want, or there is a hard time others understanding what I'm saying..

You know what a warm-standby database is?   Of course you...

You could use Bill Wunder's DDL Archive Utility for SQL Server. Have it turned on and then you can check Visual Source Safe for ANY change. I do...

Creating a temp table (or table variable) is probably the best way, especially if the procedure is going to get large, or you want to manipulate the output with a...

NULLs are not indexed.. they there are cause a table scan to be performed.

So, if you have a date field that is 'Date of Death' and search it for everyone...

o What database are you wanting the script to run it? Does the script control that?

o Did you test the script in QA? What were your results there?

o...

Scorpian,

How often do you run the scheduled 'dbcc sqlperf(waitstats)' command? Once a minute maybe?

For stored procedures, I always include SET NOCOUNT ON as the first statement. I don't want the stored procedure to return those "1 row affected" output and only output...