April 1, 2002 at 4:38 pm
In SQL Server, what is the easiest and safest way to copy one/all stored procedures from one SQL Server database to the other?
April 2, 2002 at 6:42 am
Open Enterprise Manager
Drill thru to your server then to the database.
Right click the database in the tree view side of EM and select All Tasks/Export Data...
Now in the Wizard go next and set your source and desctination information.
Then select "Copy object and data between SQL Server databases".
Next screen uncheck "Copy Data", uncheck "Copy all objects", and uncheck "Use default options"
And now click on the "Select Objects Button", there uncheck all but "Show all stored prcedures" and press the "Select All" button, "Check" button and "Ok"
Now press the "Options" button and uncheck all table options then press "Ok" (Note: if your users account does not exist on the other server check copy logins item under Security Options section.)
Press next and make sure "Run Immediately is defaulted" then press "Next" and finally "Finish".
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply