The choice of words was, in truth, a poorly written spec. It left way too much room for assumption. My "assumption" was that if there was a 3 way tie...

I would certainly attend a class given by one of you, although I much prefer Colorado (at any time of the year) to Florida.

I use this:

xp_cmdshell 'del /Q  {your stuff here}'

The /Q means quiet mode and doesn't ask for confirmation.

you'll need to do it in a DTS package using using the copy object task.

Look at this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp

At the time I tested Litespeed it had (or has) a Native Command Substitution that loads as a service and capture native SQL maintenance plans as they execute re-routing them...

Utilicé a un traductor también. Otra cosa para mirar es la longitud media de la línea para cada disco físico en el perfmon. Si está sobre 2, usted tiene un...

To read the current SQL error log, you could use xp_readerrorlog. Dump the ouptput into a temp table and examine it for keywords. The output of the xp is a...

-- Begin Main procedure --

BEGIN

Open get_cases

WHILE @@FETCH_STATUS = 0 Begin

Fetch Next

From get_cases

Into @v_case_id

END

CLOSE get_cases

deallocate get_cases

END

As part of your process, you may want to think about adding a DTS/Transfer Login task from production to deveolopment. After restore, use the sp_change_users_login to link the users to the logins....

I don't know if this is typo in the post but you have a \\ in the path.

copy the sp_who2 proc into another and  modify that one to return only what you want.

From BOL:

SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or when...