IDENTITY_INSERT not working

[iminore]

I'm running this in ASP:

objConn.Execute("set identity_insert Keywords on&quot
objConn.Execute("insert into Keywords (keywordid,keyword) values(1,'abc')&quot

I keep getting the message that identity_insert is not set on for table. I see references to dbo qualification in related views and SPs being a potential problem, but I've removed them.

Any ideas?

 

[LFCfan]

objConn.Execute("set identity_insert Keywords on insert into Keywords (keywordid,keyword) values(1,'abc')&quot

try the above
i've not tried this from VB, but i had a similar problem using dynamic sql. basically (in dynamic sql at any rate) it's to do with the identity_insert command being executed by a different connection to the insert command, so the insert command can't "see" that identity_insert has been set to on

hope this helps
LFCfan

 

[iminore]

thanks lfcfan - that works