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