Search titles only By: Search Advanced search… ...

Your SQL Server user ID must have sufficient authority to reset an identity seed. If you are the table's owner, this grants the authority, as does a sysadmin or db_ddladmin user type.

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.

Have an application written in Cold Fusion querying a SQL Server 2000 database which, as far as standard record inserts are concerned, has never has an ...