Problems with VS90SP1 and SQLCLR UDA deployments - by ktegels2

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 344093 Comments
Status Closed Workarounds
Type Bug Repros 12
Opened 5/14/2008 12:10:30 PM
Access Restriction Public


Consider the attached UDA code. This code compiles and is known to work when manually deployed to SQL Server 2008 build 10.0.1300.13 X64.

The Visual Studio Deployment feature appears to have two problems:

a.) It does not recognize a MaxByteSize of -1
b.) It does not recognize multiple paramaters can be passed into a SQL/CLR UDA in 10.x
Sign in to post a comment.
Posted by Joel Mansford on 12/31/2010 at 8:48 AM
"By Design" - you are implying that Visual Studio was designed not to allow development of features present in SQL Server!
Posted by Andrew Theken on 11/19/2010 at 6:38 AM
The suggested "work around" completely ignores the value of having the "Deploy" feature for a C# assembly in VS2010.

As soon as a single Aggregate function with more than one parameter is added to the project, a critical feature in testing the assembly becomes unusable. How is this by design?
Posted by Alan Waiss on 10/22/2010 at 12:19 PM
This *can't* be by design. It's a flaw.
Posted by rathor on 10/12/2010 at 7:40 AM
I think 7-14 days have passed :-)
Posted by Mihai Drebot on 6/17/2010 at 8:53 AM
While there is a workaround for deployment, it does not help with the debug.
Posted by Microsoft on 5/15/2008 at 3:30 AM
Thank you for your feedback. We are currently investigating. The investigation process normally takes 7-14 days. If this issue is urgent, please contact support directly (see

If at any time your issue is closed unsatisfactorily, you may edit your issue via Connect and change the status to “Active.”

Thank you,
Visual Studio Product Team