• SET IDENTITY_INSERT dbo.tblTransactions ON - that worked... thanks!