restore only stored procedures 1

[jonasggg]

hello.
I was updating many stored procedures on my notebook.
Now i need to restore to the server database but i cant find the way to restore automatically only the stored procedures to the exising database. Could someone help me?
thanks in advance.

 

[SQLDenis]

right click in the stored procedures portion of EM
select all tasks-->generate scripts
select all the procs that you want
connect to the server with QA and run the script

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jonasggg]

thanks denis for your replay.
but the updated stored procedures are in my notebook.. which i want to updated on my server.

(i have a copy of the database in my notebook where i use to work on my programs)

 

[SQLDenis]

yes, you script them out on your local machine
then connect to your server with query analyzer
open the script or paste if you copied it
then run it

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jonasggg]

ah ok
i got it!
Thanks

 

[SQLDenis]

and make sure you don't have drop dependent objects checked while you created the script, believe me, you don't want the headache

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/