Visual Studio and .NET Framework Home
Problems with VS90SP1 and SQLCLR UDA deployments
as By Design
5/14/2008 12:10:30 PM
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
Visual Studio 2008 Service Pack 1 Beta
Operating System Language
Steps to Reproduce
Compile the shown code and attempt to deploy.
Errors as noted above.
Deployment works as expected.
TAP Code (if applicable)
You can indicate your satisfaction with how Microsoft handled this issue by completing this quick
3 question survey
to post a comment.
Please enter a comment.
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!
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?
on 10/22/2010 at 12:19 PM
This *can't* be by design. It's a flaw.
on 10/12/2010 at 7:40 AM
I think 7-14 days have passed :-)
on 6/17/2010 at 8:53 AM
While there is a workaround for deployment, it does not help with the debug.
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.”
Visual Studio Product Team
to post a workaround.
Please enter a workaround.
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.
© 2014 Microsoft