Copy Data From One Table to Another Database tabe

Question

I tried to Copy Data From One Table to Another Database tabe

my stored procedure is

set

INSERT

identity_insert JewelSoftInt20110308.[dbo].[category] on INTO JewelSoftInt20110308.[dbo].[category] SELECT* FROM JewelSoftInt20110310.[dbo].[category]

set

identity_insert JewelSoftInt20110308.[dbo].[category] off



i get error message

Msg 8101, Level 16, State 1, Line 5

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.