Posted by chris on 10/07/89 12:01

I've written a C# trigger on Developer_Box, using VS 2005
Professional.
I need to deploy it on Test_Server, running SQLServer 2005.

It compile fine, and the references to the appropriate database and
table are correct.


First attempt:
You do not have CREATE Trigger permission.
Solution - Walk over to Test_Server, open management studio and give
myself CREATE Trigger permission.

Second Attempt:
"Cannot create the trigger 'MyTrigger', because you do not have
permission."
What it doesn't tell me is what permission is missing.

I could run this as admin, but I'm going to need to deploy it on
Production_Server eventually, so I want to request the minimal
permission set possible. (And I won't get admin on Production)

compatibility mode is 90;
CLR is enabled via sp_configure (and RECONFIGURE was run)

• Next in forum: Call for speakers for LinkedData Planet (June 17-18, 2008 in New York City)
• Prev in forum: Important about MySQL Certification
• Thread view: Deploying CLR trigger to SQL-Server 2005 -- Permissions Required.

[Reply to this message]