Home Dashboard Directory Help

Problems with VS90SP1 and SQLCLR UDA deployments by ktegels2


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 344093
Opened: 5/14/2008 12:10:30 PM
Access Restriction: Public
User(s) can reproduce this bug


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 http://support.microsoft.com).

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
Sign in to post a workaround.
Posted by ktegels2 on 5/14/2008 at 12:12 PM
You can work around this by issuing the appropriate CREATE ASSEMBLY and CREATE AGGREGATION statements in T-SQL.