Error In Database Tool SQL
I have a rather messy SQL Server query that runs fine in MicrsoftSQL Server Management Studio but in SOATest's DB Tool it is throwing this error at runtime:
SELECT failed because the following SET options have incorrect settings:
'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with indexed views and/or
indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data
type methods and/or spatial index operations.: 01000
The only mention of nulls in the query is at the starta when it checks for the temp table still existing and if so, it drops it:
IF OBJECT_ID('tempdb..#EVENTLOG') IS NOT NULL DROP TABLE #EVENTLOG
I have tried using this statement at the top of the query: SET CONCAT_NULL_YIELDS_NULL OFF but I still get the error. Any ideas what I may be doing wrong?
Thanks!