Unfortunately i'm getting the same error!

Msg 8101, Level 16, State 1, Line 6

An explicit value for the identity column in table 'NDP-MWD.dbo.Comments' can only be specified when a column list...

Hi,

Thanks for the reply.

I first had syntax errors and had to change it to: INSERT INTO [NDP-MWD].[dbo].[Comments] SELECT * FROM [NDM-MWD].[dbo].[Comments]

Now I'm getting this message:

Msg 8101, Level 16, State 1,...