Re: identity on / off

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

To add on, you can not switch of the Identity property using a TSQL. But you
could reseed the identity
value using DBCC CHECKIDENT command.While resseding ensure that primary key
violation will
not happen incase the identity column is associated with PKey.



Thanks
Hari


"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:%23yU32r86GHA.4604@xxxxxxxxxxxxxxxxxxxxxxx
You can't 'turn' it on and off.

You can add a new column, transfer data if appropriate, and remove the old
column.

Enterprise Mangler creates a new table and transfers the data from the old
table to the new table. (One of the many reasons that EM is NOT a good
tool to use to manage your databases.)



--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

lue "David Kwon" <tjk_guard-msnewsgp@xxxxxxxxx> wrote in message
news:e0MFUC86GHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
does anyone know syntext to turn on / off Identity field? I usually do
this
via EnterpriseMgr but I want to do this via SQL.







.

Relevant Pages

  • Re: identity on / off
    ... You can add a new column, transfer data if appropriate, and remove the old ... Enterprise Mangler creates a new table and transfers the data from the old ... Most good judgment comes from experience. ... via EnterpriseMgr but I want to do this via SQL. ...
    (microsoft.public.sqlserver.clients)
  • Re: Hide databases in EM/QA
    ... Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query ... Most good judgment comes from experience. ... How can I hide all other databases from client? ...
    (microsoft.public.sqlserver.security)