December 8, 2005 at 11:11 am
I have a large number of Access tables that I need to periodically bring to SQL using the DTS Wizard in SQL 2000 (via Ent. Man). I am only interested in bring over the data from the MS Access tables as I had a separate script (application drive) that would create the SQL tables.
The problem is this: with SQL 2000 when bringing over the tables, the check box for 'Enable Identity Insert' for each of the tables was checked, this worked fine.
With SQL 2005, this checkbox is not checked hence, I have to click 'edit' for each of the table data being brought over and check the 'Enable Identity Insert' box manualy.
My question is whether there is a way to have SQL 2005 have this 'Enable Identity Insert Box' checked by default as it did with SQL 2000.
Thank you,
Ben
December 12, 2005 at 8:00 am
This was removed by the editor as SPAM
December 14, 2005 at 8:44 am
We will need to find a way at our organization to have the "Enable Identity Insert" checkbox ticked by default in the DTS wizard. I suppose there is some way to set this in some system table somewhere. Hopefully MS has provided an SP to modify these DTS settings so that people will not need to manually modify system tables. I will post here if I find anything. Hopefully someone who knows SQL2005 well will see this thread.
Why MS chose to leave "Enable Identity Insert" unchecked by default, who knows. That is definitely going to cause issues for a lot of their customers.
December 14, 2005 at 10:26 am
Hi, I thought I would post my findings on this. Follow the link for my other thread on the MSDN forums.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply