Loading

Copy table Data from one Database to Another database

Abdu Rafeeq

i tried by this stored procedure

set

INSERT

set

identity_insert DbName.[dbo].[TblName] off

i get error message is that

"

An explicit value for the identity column in table 'JewelSoftInt20110308.dbo.category' can only be specified when a column list is used and IDENTITY_INSERT is ON.

"INTO ToDbName.[dbo].[tblName] SELECT * FROM FrmDbNme.[dbo].[tblName]identity_insert Dbname.[dbo].[Tblname] on

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Guest User15y ago
You can't use the * wildcard -- you have to specify the column names. That's what the error message is referring to by "column list".