[thelist] SQL DTS Transfer
Rory.Plaire at wahchang.com
Rory.Plaire at wahchang.com
Wed Aug 29 13:13:33 CDT 2001
| Why doesn't SQL Enterprise Manager maintain Primary Keys and
| Identities
Ben,
I'm guessing this relates to your issue, if not, I'll ask for the wet
noodle:
The Identity attribute in SQL Server is autoincremented. This means that it
is generated and inserted as rows are added. So, adding a row with the
autoincremented field will potentially conflict with a later value which was
generated by the server.
There is a way you can make a table accept the identity attributed field,
but it involves altering the table.
<rory disposition="happily" alt="8)"/>
More information about the thelist
mailing list