I must have done something, while trying to use SqlDependency in a program I was writing (though I'm not sure what - it was pretty straight forward, though there might have been some behind the scenes action).
Now all our users are getting the above error in various parts of GP.
More details describes it like this:
I was able to clear two of those SET options by changing the System DSN and checking "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, warnings", though the last one still remained.
Even so, changing EVERY users DSN is not a great option, obviously something happened on the DB to effect everyone - how could I change this back?!
Now all our users are getting the above error in various parts of GP.
More details describes it like this:
Code:
[Microsoft][SQL Native Client][SQL Server]INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexesI was able to clear two of those SET options by changing the System DSN and checking "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, warnings", though the last one still remained.
Even so, changing EVERY users DSN is not a great option, obviously something happened on the DB to effect everyone - how could I change this back?!