Re: identity on / off

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

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


"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
    ... value using DBCC CHECKIDENT command.While resseding ensure that primary key ... 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. ...
    (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)