I am connecting to a SQL Instance for backend access to a Microsoft Dynamics implementation, suggestions are unable to load on these databases only.
I used Query Store to find the query that runs on the server.
SELECT c.column_id,
c.name,
c.object_id,
c.user_type_id,
c.is_identity,
c.is_computed,
c.max_length,
c.is_nullable,
c.[precision],
c.scale,
c.default_object_id
FROM sys.all_columns c WITH (NOLOCK)
ORDER BY c.object_id, c.column_id
Running this query on the server results in the following error:
Msg 40000, Level 16, State 1, Line 1
{"Message":"Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon."}
The query runs successfully without the WITH (NOLOCK) included.
Database Version: Microsoft SQL Azure (RTM) - 12.0.2000.8 May 9 2025
SQL Prompt Version: 10.16.12.16519
I am connecting to a SQL Instance for backend access to a Microsoft Dynamics implementation, suggestions are unable to load on these databases only.
I used Query Store to find the query that runs on the server.
SELECT c.column_id,
c.name,
c.object_id,
c.user_type_id,
c.is_identity,
c.is_computed,
c.max_length,
c.is_nullable,
c.[precision],
c.scale,
c.default_object_id
FROM sys.all_columns c WITH (NOLOCK)
ORDER BY c.object_id, c.column_id
Running this query on the server results in the following error:
Msg 40000, Level 16, State 1, Line 1
{"Message":"Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon."}
The query runs successfully without the WITH (NOLOCK) included.
Database Version: Microsoft SQL Azure (RTM) - 12.0.2000.8 May 9 2025
SQL Prompt Version: 10.16.12.16519