Short form answer, without the BOL lookup:

Look at it from the perspective of the production server:

Push users the processers/CPU of the production server to 'push' the data sets to the...

Any particular reason you can't add the GetDate() to the insert statement?

I realize you are inserting from a flat file, but even if it's a DTS package using data transformation...

Add a new step to the maintenance job. Have that step exec sp_start_job:

sp_start_job [@job_name =] 'job_name' | [@job_id =] job_id

    [,[@error_flag =] error_flag]

    [,[@server_name =] 'server_name']

    [,[@step_name =] 'step_name']

    [,[@output_flag =] output_flag]

ex: exec...

If you want fully automated then you have to go with replication, and the application has to be set to look for the primary server cluster, and if it's not...

Or, do as KKnudson suggested and just go to properties and set the database's recovery to simple mode - that will wipe it just like he said, then shrink the...

This will do it

Create table #DB_Name (dbname varchar (100))

Create table #results (dbname varchar (100), tabName varchar (100), colName varchar (100))

Insert into #DB_Name(dbname)

select [name] from master.dbo.sysdatabases where dbid > 6

DECLARE...

For the email address part - another cursor query has to be written to run through the result set, each database, each table and column looking for '%_.@_._%' or...

this will get you the entire way - change the # tables to non-temp if you want. I've tested it across 245 databases, worked for me in 7 seconds with...

I really think this is a good set of routines and sp's for a log shipping solution. I ran across it while looking for a solution to keep 235 databases...

If none of that helped (and the temp table should have) - try ordering your 'and' clauses so that the most restrictive one is performed first; that will limit the...

And for the plain simple, easy to understand explanation that you can use - the @id was/is returning an INT, and the + is trying to add it, by using...

Richard, you are on the right track - find a whitepaper or some other industry recognizable source and use it as your backup. Simply going in and locking everyone out...

I've been trying this all weekend - I need to go back to the drawing board as I obviously have a bad join.

Using Insert into I blew the database...

It's actually a business process that is mandating this, I'm aggregating the 25 million down to 1.8 or so million, and the update is to update the FK back to...