Moving stored procedures

We are moving an existing database to a new dedicated server. Is there a
way to copy all the user defined stored procedures? If so, what is it.
TIA
Michael
If you are using the backup and restore method to move the databases, the stored procedures are copied right along with the databases. I'm working on an identical project and that works fine for me. You can also use a DTS package with the copy database
feature.
"Michael Beck" wrote:

> We are moving an existing database to a new dedicated server. Is there a
> way to copy all the user defined stored procedures? If so, what is it.
> TIA
> Michael
>
>
|||You could also to sp_detach_db and sp_attach_db... in all 3 cases your
stored procedures will move with the database. They are stored inside the
database in a table called syscomments.,,, so they go automatically.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Michael Beck" <Mikeb46NoSpam@.pacbell.net> wrote in message
news:ewxJ38FZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> We are moving an existing database to a new dedicated server. Is there a
> way to copy all the user defined stored procedures? If so, what is it.
> TIA
> Michael
>