In SQLServer2005 I can't set the IDENTITY_INSERT to ON. Can anybody help?

Question

I am trying to set IDENTITY_INSERT to ON with "SET IDENTITY_INSERT AJAXMaster (table name) ON". But it shows me the error "The Set SQL construct or statement is not supported."
Then it shows the message that "Query has executed successfully."

Now when I am trying to insert a field containing image into this table using this query "insert into ajaxmaster values (12, 'Mr.Brahmbhatt', 'Can not set the identity_insert to ON', 'E:\logo.jpg')", it shows me "Can not insert explicit value for identity column in table 'AJAXMaster' when IDENTITY_INSERT is set to OFF."

Can anyone help me out with this? Pl.

Answer 1

May be you have not corresponding permissions:

Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner.

Thus, use the following syntax:

--
insert into ajaxmaster(f2,f3, f4)

values ('Mr.Brahmbhatt', 'Can not set the identity_insert to ON', 'E:\logo.jpg')
--

Here,
f2,f3,f4 - table colunms without identity column.