August 30, 2006 at 1:17 pm
In SQL Server 2005, Im trying to append data to tables which already exist. The goal is to import the data through the import wizard into a specific schema. The source from is Microsoft Access with no username and password but a location for the .mdb file. The source to is SQL Server 2005 using OLE DB Provider SQL Server with the login information of the schema owner I wish to use. I click through and the tables appear in the source. When I select all, they appear in the destination but they appear with the dbo. prefix which would regard them as new tables since the tables dont exist under that schema. I can click on the first destination table drop down text box and see all the tables under the schema there suppose to be under but its not the default. There are a lot of tables and I don't feel like using the drop down text box hundreds of times. Is there a solution to this problem? Thanks Scott |
September 4, 2006 at 8:00 am
This was removed by the editor as SPAM
September 6, 2006 at 9:54 am
Perhaps the dbo designation is based on how you're authenticating to the SQL Server. If you import the tables under a dbo-equivalent account (like SA), they'll be owned by dbo. Try another sql user account, or perhaps as another windows account if you're using trusted security.
September 6, 2006 at 10:14 am
To anyone reading this: Its fixed in SP1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply