SQL Server – Notes on Creating a CLR Trigger

Here are my notes on creating a CLR trigger into SQL Server 2008. If you have any questions about it, just post a comment and I’ll reply. I just wanted my notes on this one online since I’m sure others run into the same issues I did. Base Tutorial http://www.c-sharpcorner.com/uploadfile/37db1d/create-your-first-clr-trigger-in-sql-server-2008-using-C-Sharp/ Need to be sa or atleast db_admin to run some …

Missing SQL Managment Studio

I noticed that after installing Microsoft SQL Server 2005 Developer Edition that it was missing the SQL Management Studio, which embarrassingly enough was the only reason I installed the darn thing. So assuming you made the same mistake I did and that is why you are here… below are the steps to install SQL Management Studio. Make sure Windows SP1 …

C# Stored Procedure Example

This is a quick example of how to make a call to a SQL Stored Procedure using C#. Make sure that the datatypes you declare match what the SQL table can hold. In another post I’ll give a RegEx Class that can wash out errant data and verify that everything is typed correctly (So you don’t enter a string where …