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,
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