SQL 2008 CLR Triggers, use a .NET class library in SQL using WPF
Posted by: Al Pascual,
on 27 Jul 2009 |
View original | Bookmarked: 0 time(s)
Since SQL 2005 you can add .NET dlls into the SQL Assemblies, therefore get called on triggers and event from SQL to do something. Those should be simple utilities as the installation is still quite painful. Now when you are trying to use WCF or WPF dlls referenced on your application that could be a little harder. Youll have to reference all the assemblies by hand that means setting the trust level . ALTER DATABASE DatabaseName SET TRUSTWORTHY OFF use MASTER GRANT UNSAFE ASSEMBLY to public...