Does the table exist?

Do you have permissions to the table?

What is your user accounts default schema? If it is different than that of the table, you will need to append the schema name to the object

SET IDENTITY_INSERT dbo.tblTransactions ON