Activity overview
Latest activity by jmatap
Hi Brian,
Thanks for the response.
I have tried without the 'Do not use ALTER ASSEMBLY to change CLR types' option but that doesn't always work because as per MSDN - ============================ ALTER ASSEMBLY statement cannot be used to change the following:
- The signatures of CLR functions, aggregate functions, stored procedures, and triggers in an instance of SQL Server that reference the assembly. ALTER ASSEMBLY fails when SQL Server cannot rebind .NET Framework database objects in SQL Server with the new version of the assembly.
- The signatures of methods in the assembly that are called from other assemblies.
- The list of assemblies that depend on the assembly, as referenced in the DependentList property of the assembly.
- The indexability of a method, unless there are no indexes or persisted computed columns depending on that method, either directly or indirectly.
- The FillRow method name attribute for CLR table-valued functions.
- The Accumulate and Terminate method signature for user-defined aggregates. ============================
I am trying to find a solution that will always work while deploying CLR Assemblies to QA database.
Thanks.
- jmatap / comments
Hi Brian,
Thanks for the response.
I have tried without the 'Do not use ALTER ASSEMBLY to change CLR types' option but that doesn't always work because as per MSDN -============================ALTE...
Dependency issues/errors synchronizing CLR Assemblies
Hello
I am getting errors while executing script generated by SQL Compare to synchronize CLR Assemblies on the target database. Here is my situation.============================
Assembly A with
- a...