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

Francisco H Tapia my.lists at verizon.net
Wed Dec 31 11:32:33 CST 2003


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




More information about the dba-SQLServer mailing list