Copy table Data from one Database to Another database

Question

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

John Penn · Answer

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.