Niels SQL Server Blog

musings about SQL server

<October 2008>
SuMoTuWeThFrSa
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678


Navigation

Subscriptions

Post Categories



SQlClrProject - Visual Studio Project Type for SQL Server 2005

My blog has moved to sqlblogcasts.com/blogs/nielsb
The full version of this post can be found here., http://sqlblogcasts.com/blogs/nielsb/SQlClrProject - Visual Studio Project Type for SQL Server 2005
The new RSS feed is here

I have the pleasure to introduce the SqlClrProject project type.

The SqlClrProject is a project type for Visual Studio 2005 for creation and deployment of assemblies to SQL Server 2005. It consists of  templates for both Visual C# (C#) and Visual  Basic (VB) with skeleton code for creation of CLR methods to be used as stored procedures, User Defined Functions (UDF’s), triggers, User Defined Types (UDT’s) and User Defined Aggregates (UDA’s). Some of the features are:

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/nielsb/SQlClrProject - Visual Studio Project Type for SQL Server 2005

posted on Tuesday, June 21, 2005 10:10 AM by nielsb


# re: SQlClrProject - Visual Studio Project Type for SQL Server 2005 @ Tuesday, June 21, 2005 10:16 AM

Hey, thanks for stealing my idea! I've been thinking about this for a while, but have been too lazy to implement it. :)

Seriously, though, great job! I don't really understand the SKU limitations, and this combined with your deployment task pretty much eliminates them -- although is there any possibility of an F5 debug in a lower SKU? I assume lower SKUs can attach to the SQL Server process for debugging, if that's not available... Just a few more clicks away.

amachanic

# re: SQlClrProject - Visual Studio Project Type for SQL Server 2005 @ Tuesday, June 21, 2005 11:58 PM

Thanks Adam!!!

The SKU limitation for VS is just sales/marketing BS. AFAIK, there are no technical reasons for the limitation.

Niels

nielsb

# Deployment of SQL2005 assembly in VS.NET 2005 @ Monday, July 04, 2005 6:11 AM

Anonymous

# Deployment of SQL2005 assembly in VS.NET 2005 @ Monday, July 04, 2005 6:13 AM

Anonymous

# Visual Studio Project type for SQL2005 @ Monday, November 21, 2005 6:12 PM

Anonymous

# Visual Studio Project type for SQL2005 @ Monday, November 21, 2005 6:13 PM

Anonymous




Powered by Dot Net Junkies, by Telligent Systems