Error with nolock

Toad Data Point & Toad Intelligence Central
1

I have created a query using the diagram. When I try to edit and add a (nolock) to it, then I keep getting the message that it is not synchronized to the diagram and will not let me save it. I have other queries that has the nolock with no problems. Is their a bug when editing from the Query tab?

Second question is if the query is set for Read Only, does this accomplish the same as the nolock statement?

SELECT MessageLog.DateTyme AS Msg_Date,

SystemDefinition.ExtID,

SystemDefinition.[Name],

MessageLog.[Message]

FROM ConnectR.dbo.MessageLog MessageLog (nolock)

INNER JOIN ConnectR.dbo.SystemDefinition SystemDefinition

ON (MessageLog.SystemID = SystemDefinition.SystemID)

WHERE (MessageLog.ErrorStatusID = 2)

ORDER BY Msg_Date ASC, SystemDefinition.ExtID ASC

2

You need to press the visual query button. This should sync up the query tab with the diagram.

2804.VisualIizequery.png

3

The diagram does not accept (nolock) statements. I add them in for safety but in some cases, I cannot save the query with the statement in it.

4

What type of database is this? Teradata? SQL Server?

5

Sql Server 2005

6

I entered QAT-3167 however it does not look like we can fit it in for TDP 3.6. Will try to TDP 3.7

7

Has the “visualize SQLstatement” functionality been upgraded to recognize WITH (NOLOCK) hint?