Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2002-08-27 : 05:05:53
|
| hi,How do i import all stored procedures from 1 database to another?thank youSam |
|
|
mohamedyousuff@yahoo.com
Starting Member
24 Posts |
Posted - 2002-08-27 : 06:01:07
|
Open the Enterprise Manager, right click the database in which you have the stored procedures to be transferred (source). Choose Export Data and then choose the source and destination database; In the next screen choose 'copy objects and data ...'; Next screen remove the check box on 'copy all objects' and click on the button titled 'choose objects'. Now select all the stored procedures. Further steps are self-explanatory.S.Mohamed Yousuffquote:
hi,How do i import all stored procedures from 1 database to another?thank youSam
|
 |
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2002-08-27 : 06:08:28
|
| thanx for replyin!!i tried that..but it gives me some error as USER DOES NOT EXIST..while it exists in both databases.thank youSam |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-27 : 15:47:52
|
| In the options you probably have checked "Copy object-level Permissions". It is trying to grant permissions on one or more of the stored procedures to a user that does not exist in the destination database. Un-check this option or create the user. |
|
|
|
|
|
|
export/import