You’re offline. This is a read only version of the page.
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:
[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 indexes
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?!
*This post is locked for comments
I have the same question (0)
I restarted the MSSQL Service, it is working now.
Share
Report
All responses (
Answers (
