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 |
|
ssingh
Starting Member
25 Posts |
 Posted - 2002-02-07 : 16:25:54
|
| I created a new database, and I want to transfer a number of tables and stored procs to this database from an existing database on the same server. I had no problems transfering the tables, but I can't transfer the stored procs. This is the error I'm getting:'Failed to transfer Objects from Microsoft SQL server to Microsoft SQl server'.If I double click the error I get:[Microsoft][ODBC SQL Server Driver][SQL Server]The login already has an account under a different user name.Please let me know how can I resolve this.Thanks |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-07 : 17:29:58
|
| Looks like you are trying to transfer logins. Go into the advanced properties, and deselect everything but the stored procs.-Chad |
 |
|
|
ssingh
Starting Member
25 Posts |
Posted - 2002-02-08 : 07:58:43
|
| I'm not trying to transfer logins. I'm trying to transfer a whole bunch of stored procs from database to another |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2002-02-08 : 08:04:06
|
Look in the bottom left hand corner(in SQL 7). I'd bet you're using default options, which attempts to transfer logins/permissions as well. Change this and set your options manually and you should be fine.Mike"..still no custom title"  |
|
|
|
ssingh
Starting Member
25 Posts |
Posted - 2002-02-08 : 09:15:30
|
| Thanks Mike. It worked |
|
|
|
|
|
|
Using DTS package to transfer stored Procs