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
MichaelYou 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
>