Backup/restore is a good plan, log shipping more trouble than its worth for this change (and it essentially does the same thing anyway). The key is that you're going to...

Im definitely against any data type desc in the column name. Where I work, we have an app that uses "foreignkey" for all the foreignkey cols. Guess what it calls...

Not directly. The only way to keep them out would be to set the db to either dbo only or single user mode, or you could temporarily change their permissions...

Connection pooling and/or object pooling may be the issue here. I havent had any problems with @@rowcount (have you checked MSDN to be sure though?). I would suggest you test...

Do you know the stored proc is executing for sure? How about adding some logging to the proc so you can see if it's running and what value was passed?

Andy

...

Couple questions. How do you get an int to hold that value? The max value is 2,147,483,648 (or (214) 748-3648 as a phone number!) Another question is why did you...

Easiest way would be to run Profiler while you create the package, that should give you the list without too much work!

Andy

Honestly I dont know:-) I think the package will run ok, the question is how will the data look. You might want to pull some data out of the db...

Im not sure I agree with a separate drive for the pagefile. I know it's recommended, but if you're even close to properly configured, you shouldnt be hitting the page...

They should all execute independently, assuming that running one doesn't cause another to be blocked by locking of the data. Not impossible, but I think 1000 at once would be...

If you're using SQL2K you could just change the collation to match the old one.

Andy

You cant use the results of a stored proc directly in TSQL (ADO is often a better choice for these types of things). The easiest way to do it in...

We keep ours local, data on fibre. Nice and simple, plus good separation if you're having a problem with your storage.

Andy

I'd vote for the SQL dump to disk as well. Easy and reliable.

Andy

I've got some sample code posted in an article http://qa.sqlservercentral.com/columnists/awarren/dmointro.asp that you may find helpful, plus a couple other articles on DMO, including one about how to restore.

If...