Matt
Member since Feb 28, 2014
- Profile: /members/11662-matt.htm
- Comments: 1
Recent Blog Comments By Matt
-
Turning Off and On Identity Column in SQL Server
Posted on Feb 28, 2014 at 11:19 AM
@Stephen - Make sure that the table with PK that the FK refers to is populated first. Also, you can only have one table at time with SET IDENTITY_INSERT set to 'ON', so you must set it to 'OFF' if you before setting it to 'ON' for the next table in a script. See the 'Remarks' section of this: http:... read more »