Use Enterprise Manager to script all of the stored procedures from the database.

Then you can execute the created script when connected to the new database in Query Analyzer.

    Rick 

You should not be using the "GO" statements.

Set your default database on the connection that you are using instead of trying to use the "USE" statement within the TSQL.

Break the...

Have you considered stacking all of your hourly log dumps onto a single file.

The process that I use is to stack all of the log dumps onto a single file...

For the backups.

Having your backups only on tape is not as safe as having backups ("Dumps") on both tape and disk.  If you need to quickly restore data having it...

This was generally a problem with the input data that was being converted.

For instance trying to push a bogus date into a "Not Null" date column.

Are you able to re-run...

Is this happening at the same general time everyday?

Are you perhaps running a database maintenance plan?

I would get this when performing index maintenance "dropping / creating" indexes on a table while users have server side cursors open.

This Chicago area SQL user group meets on June 28th at 5:30 PM downtown in the Microsoft office building (77 W. Wacker Dr., Suite 2300).  The topic is "Getting Ready...

The experience that I have had is that the 4 x 3 GHz CPU's will outperform the (4 year old) 8 x 700 MHz CPU's (Even if hyper threading is turned off).

At...

Angela

The process that you use is a correct one.  As stated by Remi, the statistics follow the internal object_id of the table and do not use the logical table name.

The...

Are you using the "with (NOLOCK)" optimizer hint on the tables within the query?

What is the reason for the normally poor performance (1.5 Seconds)?  Is the view scanning large tables...