WAITFOR TIME would delay the process till 11 PM.

What you want to do to make it stop at 11 PM is add something to the While statement:

and datepart(hour, getdate()) <...

Suggest my two-temp-tables-and-an-update method, see if that gets what he wanted.

Sounds like, if they get the right job for you, it might be a good opportunity.

I figured the test would be something like that. I wouldn't be able to...

First, assign the string to a variable. Then, use two-single-quotes where you want single-quotes in the string. Then use the variable in the parameter.

declare @Q varchar(1000)

select @Q =...

Not sure exactly what you mean by "number of hits". If you mean how many queries it sends to the database, you can run a trace to track that....

Why would you have to make it a proc to use a function like FileProperty? Just set the right columns to be the input parameters, and use Cross Apply...

You could select from the sys.sysaltfiles DMV, and use a running total expression for the size. That would give you what you need.

Where it displays the target table, you can either type in an existing table, or click the down-arrow next to that and it will let you select an existing table.

Make...

Try something like this:

WITH EmployeeSubordinates (EmployeeID, LastName, FirstName, DistinguishedName, Mail,

Manager,Tier,Seq) AS

(

SELECT

...

It appears to me, from the limited data given, that this should do what you need:

select distinct tblClientImport.StmtNum, tblStatements.Stmt,

tblStatements.Count_Range, tblStmtChar.CharNum,

tblCharactersists.Characteristic

from tblClientImport

inner join tblStatements

on tblClientImport.StmtNum = tblStatements.StmtNum

inner join tblStmtChar

on...

Make it two single-quotes in a row.

'O''Donnal'

'Sam''s'

DTC can generate negative SPIDs.

On the first question, it depends on your data, indexes and what your query is doing. I would guess that 10 years data would be 10 times as many...

Is it possible for you to have some sort of LoadDate or BatchID in the clustered index? If so, then that will really expedite your re-indexing process. If...

Have you run UpdateUsage and CheckDB and updated all the statistics in the 2005 version of the database? (Assuming this is a migration from 2000 to 2005.)