March 12, 2007 at 11:04 am
Hello Experts,
I'm have a task that is causing some problems with SQL Server 2005. I'm trying to copy a database including all sps (SQL Server 2000) into a new database (SQL Server 2005) but I'm not able to select only the master stored procedure. Is ther a option to select all of the store procedures instead of the master storded procedures.
Thanks for your help!
Ryan
March 13, 2007 at 8:29 am
Hi Ryan,
Unless you have a specific need to recreate the entire db from scripts, I would suggest a simple backup and restore of the db you need a copy of. That would move everything in a very efficient way.
Otherwise, you can use the copy database wizard (search in Books Online)
Good luck,
AB.
March 13, 2007 at 9:12 am
Hey Andrew,
Thanks for the information...I'm conducting a backup and restore of the database as we speak...I think may be the answer. Thanks
Ryan
March 15, 2007 at 5:24 am
Check the default database selected in your connection. may be your connection is lying in master db. and hence not showing you procs from your own database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply