Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 need to take advantage of NOT FOR REPLICATION without replication installed

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-09 : 00:54:03
Greg writes "I need the functionality of the NOT FOR REPLICATION option for an identity column, in that i need to make inserts sometimes where i dont want the current identity value to increment. The way I understand it is that the NOT FOR REPLICATION option does this whenever a replication agent makes the insert into the table. The problem is that I dont want to use replication, so is there a way that I can make the insert as if I was the replication agent so it takes advantage of this option? or is there another way to accomplish the same thing?
Thanks in advance
Greg"
   

- Advertisement -