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)
 Cannot insert explicit value for identity column

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-28 : 07:46:36
shree writes "I am importing data from Sql Server 2000 DATABASE TO same server another database from vb.How to set the Idenity_insert for the importing database"

dsdeming

479 Posts

Posted - 2003-04-28 : 08:28:10
Try SET IDENTITY_INSERT Tablename ON.

Go to Top of Page
   

- Advertisement -