How to import/export stored procedures in SQL Server?? I used DTS, but it
only transfers all tables, excluding views, stored procedures, etc...


please help. thanks!

If you are using the DTS Import/Export wizard, make sure
you choose to "Copy Objects and Data" instead of "Copy
Tables and Views".

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com

In Designer there is a Copy SQL Server Objects task which will do this for
you. Personally I would use a script to copy these objects out and reapply
them.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Matthew Louden" <mattloude (AT) hotmail (DOT) com> wrote