Copying Stored Procedures fails

[Bruce Wexler]

Hello,

When I transfer/copy tables from one database to another (on the same SQL Server), everything is fine. When I try to tranfer/copy Stored Procedures, I get the error message:
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server."

I am using the DTS import/export wizard to do this.

Thanks,
Bruce

[Me]

The SP probably depends on objects that don't exist in the destination database. Try scripting the SP and creating it manually.


------------
Bruce Wexler at 5/10/01 11:25:17 AM

Hello,

When I transfer/copy tables from one database to another (on the same SQL Server), everything is fine. When I try to tranfer/copy Stored Procedures, I get the error message:
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server."

I am using the DTS import/export wizard to do this.

Thanks,
Bruce

[Jesal]

It can be permission issue..try to deselect all the security option checkbox when you do it


------------
Bruce Wexler at 5/10/01 11:25:17 AM

Hello,

When I transfer/copy tables from one database to another (on the same SQL Server), everything is fine. When I try to tranfer/copy Stored Procedures, I get the error message:
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server."

I am using the DTS import/export wizard to do this.

Thanks,
Bruce