Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger is locking up record
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00899034
Message ID:
00901476
Views:
42
I've been up and down this thread and it looks to me like this is an environmental issue.

Can you tell me what you have for your setting of IDENTITY_INSERT ? Is the login different in your registered server in SEM, compared to how you are accessing this database from the QA ? Have you got permissions to actually do inserts using the SEM login?

Permissioning and rights management may explain how Sergey and Michael can run your script, but not yourself.

Simon
SJC Systems Limited
WorldSpreads Limited (www.worldspreads.com)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform