CREATE AGGREGATE failed because type concatenate does not conform to UDAGG specification due to method ‘Accumulate’.
Please follow these steps to solve the issue:
1. Open the project in Visual Studio
2. Click on the project properties
3. Go to the Database tab and click on the browse button next to the connection string. You will get the Add Database Reference dialog.
4. Click on Add New Reference
5. In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate.
6. Now drop and reregister the assembly and then create aggregate function in the database you want.
Advertisement
