In creating a query that will be used in Query Notification, how are the SET options determined for the query?
Answer: A specific group of SET options are required on the client.
Explanation: When building a query for query notification, a specific set of SET option setttings must be on the client’s connection. specifically they are:
- ANSI_NULLS ON
- ANSI_PADDING ON
- ANSI_WARNINGS ON
- CONCAT_NULL_YIELDS_NULL ON
- QUOTED_IDENTIFIER ON
- NUMERIC_ROUNDABORT OFF
- ARITHABORT ON
Note:: The question of day is taken from SqlServerCentral.com. I want to compile selected QOD to share.