Monthly Archives: November 2009

CLR trigger – External access

By default when you create a CLR trigger, VS 2008 will deploy it as a SAFE trigger: CREATE ASSEMBLY HelloWorld FROM @SamplesPath + ‘HelloWorld\CS\HelloWorld\bin\debug\HelloWorld.dll’ WITH PERMISSION_SET = SAFE;   This is good, you always want to start with the minimal … Continue reading

Posted in Development | Leave a comment

CLR Trigger

Creating a CLR trigger couldn’t be easier: In VS 2008 Create a new SQL Server Project, then create a new trigger (right click project name, add, trigger. Fill in the attribute’s properties: [Microsoft.SqlServer.Server.SqlTrigger(Name = "PackageDeleteTrigger", Target = "Packages", Event = … Continue reading

Posted in Geen categorie | Leave a comment