[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