THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Enjoy Another Sandwich -- Kent Tegels

Yummy slices of SQL Server between slices of .NET and XML

Missed it by *that* much: UDAs, Deployment, VS90SP1B1 and SQL Server 2008 CTP6 (Feb'08)

Happy Spring everybody!

As of late I've been heads down working on a new course on SQL Server 2008 and its been a lot of fun. So the other way when the Visual Studio team dropped SP1 Beta1 for Visual Studio 2008 (see here) I was all over it. And it took me longer than I expected to run into... well, its not so much a bug I think as it is a misimplementation of a new feature.

One of the new features in SQL Server 2008 I am using quite a bit multi-parametered SQL/CLR User-Defined Aggregates. These are helpful in the statistical and spatial areas. For example, I just crufted up an UDA that takes a paired vector of latitudes and longitudes and constructs a LineString Geometry from them (see the code here). It is good use case where the ability to have a Large Value Type (e.g., a user-defined type or aggregate that persistence size of more than 8,000 bytes) and the ability to take in multiple parameters helps solve an otherwise cumbersome problem.

But the "deploy project" feature chokes on those features. Specifically, it doesn't seem yet to know yet that we use a MaxByteSize of -1 to indicate that the are using an LVT ('MaxByteSize' property specified was not found), nor does it seem to know how to deploy an multiple parameter UDA (The Accumulate method in user defined aggregate "DM.Examples.LineStringBuilder" must have exactly one parameter.)

I have posted these to Connect (See Item ID 344093) and if you agree with me that they should be fixed, please go vote here.

Published Wednesday, May 14, 2008 2:37 PM by ktegels
Filed under: ,



Kevin J said:

Hi Kent

I am wondering if you have found a solution to this problem other than doing it manually. I looked at the Item on Connect and they have closed it saying it is by design??

I have installed VS2008 SP1 (RTM not Beta) and it still seems to be a problem. I have a assembly which contains quite a few stored procedures and i'd like to use the Deploy function. Any help would be grateful.


August 13, 2008 4:03 AM

ktegels said:

Nope, I can confirm that this a problem with the Visual Studio 2008 SQLCLR project. I was pretty sure Niels's SqlClrProj would do this but at the moment, it doesn't seem to be offering a deploy option. I'll ping him about it this.

Now if this is a "By Design" issue or not... well, I'd call it a bug since its something that should be supported but isn't. They would say "yeah, but the spec isn't written that way so its not a bug!"


August 14, 2008 12:22 AM

ktegels said:

My bad on Niels's project, its working just fine and it does multi-parameter aggregates just fine.

Details about that at:

August 14, 2008 12:35 AM

Kevin J said:

Thanks Ken. Will get it and try it out.

August 14, 2008 8:26 PM
New Comments to this post are disabled

About ktegels

Kent Tegels passed away on July 31, 2010. Kent was an Adjunct Professor at Colorado Technical University and a member of the technical staff at PluralSight. He was recognized by Microsoft with Most Valuable Professional (MVP) status in SQL Server for his community involvement with SQL Server and .NET. Kent held Microsoft Certifications in Database Administration and Systems Engineering, and contributed to several books on data access programming and .NET. He was a well known industry speaker, and resided in Sioux Falls, South Dakota.
Privacy Statement