Right click on it and select Script As > Create and it will give you a
script that will create it. You may need to change the USE statement at the
top if the DB Name is not the same.

You'll need to set up any special permissions as well. These are the times
that special tools come in handy.

-Dave


-----Original Message-----
From: Erum Hussain
[mailto:mssqldba-ezmlmshield-x66067506.[Email address protected]
Sent: Tuesday, April 29, 2008 4:22 PM
To: LazyDBA Discussion
Subject: copy store proc from one server to another

How do you move store procedure from one server to another? This is kind
of urgent.

Thanks in advance,



ERUM HUSSAIN

DBA GROUP

[Email address protected] <mailto:[Email address protected]

770-234-3757






---------------------------------------------------
Visit us on the Web at http://www.AccessGeneral.com



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page