-
Copying Stored Procedures fails
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
-
Copying Stored Procedures fails (reply)
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
-
Copying Stored Procedures fails (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|