Migrating to new SQL server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sally (anonymous_at_discussions.microsoft.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 04:47:51 -0800

We are wanting to try and move our SQL database to a new
SQL server, but are going to have to save each plan onto
the new database one at a time as we believe that we
have 'duff' data in the database and this is how we want
to 'clean it up'

Firstly, how is the best way to move the resource pool
over to the new database? Can I just copy and paste
across?

Secondly, is there an easy way of auto approving all
outstanding timesheets that have been submitted but not
yet approved so that this data does not get lost?

Thanks - Any help would be greatly appreciated

Quantcast