Hi,
I am getting this error when running a function with a CLR:
Msg 6522, Level 16, State 1, Line 2
A .NET Framework error occurred during execution of user-defined routine or aggregate "ReplaceString":
System.NullReferenceException: Object reference not set to an instance of an object.
System.NullReferenceException:
at FindReplace.GetCompleteRuleSet(String ruleSetName, Boolean alphaOrdered, Boolean resetRules)
at FindReplace.ReplaceString(SqlString StringToReplace, String ReplaceSetName)
.
If I backup and restore the database on the same server with a different name, the error stops.
Any ideas?
Thanks.