Just wanted to add that I have been able to do some inserts but my main issue is with this error
"Explicit value must be specified for identity column in table 'mytable_Articles' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column."
My command:
SET IDENTITY_INSERT test1.dbo.mytable_Articles ON
INSERT INTO [test1].[dbo].[mytable_Articles]
([AddedDate]
,[AddedBy]
,[CategoryID]
,[Title]
,[Abstract]
,[Body]
,[Country]
,[State]
,[City]
,[ReleaseDate]
,[ExpireDate]
,[Approved]
,[Listed]
,[CommentsEnabled]
,[OnlyForMembers]
,[ViewCount]
,[Votes]
,[TotalRating])
SELECT
[AddedDate]
,[AddedBy]
,[CategoryID]
,[Title]
,[Abstract]
,[Body]
,[Country]
,[State]
,[City]
,[ReleaseDate]
,[ExpireDate]
,[Approved]
,[Listed]
,[CommentsEnabled]
,[OnlyForMembers]
,[ViewCount]
,[Votes]
,[TotalRating]
FROM tbh_Articles
Thanks for any help.
SL
|