[dba-SQLServer] Re: SQL Server 2000 - Need to change a value in a primary key...

I'm cc'ing the Sql list as this is a Sql question... :)

It's Identity Insert ON (tablename)
your update/insert statement that inclues the primay key
then Identity Insert OFF
YOU MUST turn it off otherwise it stays on the entire time (iirc of the 
session).

for more info check out BOL (Books on line)

to subscribe to the dba-SqlServer list go to
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver


Melissa Sener wrote:

>Does anybody know how to change a value in a primary key in SQL Server 2000?
>
>Melissa
>  
>

-- 
-Francisco