Question I received in Email : How to list all the columns in the database which are used as identity key in my database?
Migrating From Access to SQL Server: Data Types and Gotchas
Plan migrating from Access with explicit type mappings, boolean and date checks, query rewrites, and a primary key inventory.
SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table
Msg 544, cannot insert explicit value for identity column, happens when IDENTITY_INSERT is OFF. Turn it ON, insert your rows, then turn it OFF again.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.