How can we help you today? How can we help you today?

SQL Prompt suggestions not loading with dynamics SQL access

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

 

 

Timothy Jeffreys
0

Add comment

Please sign in to leave a comment.