I'm trying to copy stored procedures from one database to another db on the same server through DTS. Everything goes fine but the stored procedures are not getting transferred. Am I missing anything
I've SQL 2K with SP3
Please throw some ideas....

Thanks
John

What task are you using ?
If you are the using the "Copy SQL Server objects task" are you sure they're
"Checked"
Errors?



--

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

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


"SQLGuy" <anonymous (AT) discussions (DOT) microsoft.com> wrote

are not getting transferred. Am I missing anything?

I'm using DTS Export/Import wizards....

Hi

I got it.
I'm not checking the 'create destination objects check box
I'm choosing 'copy all objects' and then selecting only SPS with checks. I thought this would create SPs, but it is not
Now I could create them.

Thanks..