[dba-SQLServer]Turn Identity property of a column on/off in script

So you want to insert value into identity field?
look up SET IDENTITY_INSERT in BOL.

HTH
Billy


>From: "Susan Geller" <sgeller at cce.umn.edu>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer]Turn Identity property of a column on/off in script
>Date: Wed, 29 Oct 2003 09:46:14 -0600
>
>I have a table that has a PK field whose identity property is "Yes".  I
>need to do an insert into this table and for that I want the identity
>property to be "No".  I want to change the identity property of my
>column from "yes" to "no", then do the insert and then change it back to
>"yes" again.  I want to script this but I can't figure out how to do
>that. SQL Server 2000.
>
>TIA.  -- Susan
>
>Susan B. Geller
>Office of Information Systems
>College of Continuing Education
>University of Minnesota
>306 Wesbrook Hall
>77 Pleasant Street SE
>Minneapolis, MN 55455
>Phone:  612-626-4785
>Fax:  612-625-2568
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail