I'm trying to write a clr trigger. I have a table under a user defined schema, say Myschema.Table1. If I write something like this
[SqlTrigger(Name = "Trigger1", Target = "Myschema.Table1", Event = "FOR INSERT")]
I got this error when deploying my assembly on SQl server:
Cannot find the object "Myschema.Table1" because it does not exist or you do not have permissions
If I move Table1 in the dbo schema the assembly is deployed succesfully
Can someone help me
Thank you
This is a known bug. You will need to manually deploy the trigger to the non-dbo schema.
No comments:
Post a Comment