Monthly Archives: February 2017

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015. If you google “sign a SQL Server CLR Assembly”, you … Continue reading

Posted in SQL Development | Leave a comment

CLR Stored Procedure Cannot Be Marked as System Object?

It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored procedure sp_MS_marksystemobject as explained here. The benefit is that when you put a SP in the [master] database and mark … Continue reading

Posted in SQL Development | Tagged | 1 Comment