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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-24 : 08:34:11
|
| angelique writes "While using the "Import/Export data" feature in SQL 2000 an error was encountered "The login 'report' does not exist". This stopped the copy altogether. Does this mean the table 'report' does not exist in my database although I found it there? Please help." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-24 : 12:34:49
|
| It means that you are missing an account. The table is probably owned by an id called report. So if the id doesn't exist, then it can't create the table.Instead of using the import/export wizard, why not use BACKUP/RESTORE or DETACH/ATTACH methods. These methods are faster and are reliable. You might encounter many other errors with the wizard.Tara |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-27 : 13:12:18
|
| As you walk through the Import/Export wizard, there are options to choose whether you want the process to copy the login accounts or not. If you REALLY want a duplicate of the security, then you can tell it to copy the login information also. But sometimes you don't really want that. In that case, you may have to create the empty table in the destination and then in the wizard, map the destination to the existing table you created instead of having it create it new.If you are copying only part of the database, and do not want everything, then Backup/Restore and Detach/Attach will not work for you.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-28 : 12:03:22
|
quote:
Originally posted by AjarnMark
If you are copying only part of the database, and do not want everything, then Backup/Restore and Detach/Attach will not work for you.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url]
BACKUP/RESTORE and DETACH/ATTACH would still work though. I use it to copy our production databases to development or test environments. We don't want the users, so we just delete them afte the RESTORE or ATTACH.Tara |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-28 : 12:21:45
|
| Hi Tara! Welcome back! Glad the fires didn't get you.In my response I was thinking in terms of if you just wanted one or two tables from a database, instead of most or all of the objects.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-28 : 12:27:31
|
quote:
Originally posted by AjarnMark
Hi Tara! Welcome back! Glad the fires didn't get you.In my response I was thinking in terms of if you just wanted one or two tables from a database, instead of most or all of the objects.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url]
I was very close to the fires. It came within about 2 miles of my place. My area didn't get evacuated, but we kept watching it just in case. The fires are still going on but not near me anymore. Air quality is so horrible. They say that the quality is 90 right now and 40-65 is considered bad and 15-20 is considered normal. It is hard to breathe when you are outside. So far 800 homes have burnt down, I sure hope it stops soon.Anyway, yes for just a couple of tables then the import/export wizard is probably a good choice for someone who is unfamiliar with other options, such as INSERT INTO using a linked server if need be, bcp, BULK INSERT, etc... I try to stay away from the wizards as much as possible. They sure come in handy if you need to do something quickly though.Tara |
|
|
|
|
|
|
|
|
Database Copy