I've been having erratic problems with my where clause not popping hints. I am having this right now. I'm going to include everyting in my query window.
The where clause at the bottom is failing to show anything releveant in the window that comes up. It's showing only system functions. If I type UD. I get options like 'alter table' snippet - it doesn't seem to know it's on a select statement at all.
BUT - if I remove the (NOLOCK) it starts working. So there you go - (NOLOCK) is causing where clause prompts to fail.
SELECT * FROM dbo.CvcTransactionsLog
SELECT COUNT(*) FROM dbo.CvcTransactionsData WHERE CvcTransactionsLog_ID = 10
SELECT COUNT(*) FROM
dbo.CvcTransactionsData ctd (NOLOCK) INNER join
dbo.CvcTransactionsCASSOutput cass (NOLOCK) ON ctd.CvcTransactionsData_PK = cass.CvcTransactionsData_fk
WHERE CvcTransactionsLog_ID = 10
--UPDATE dbo.CvcTransactionsLog SET Geocoded = 0, ReadyToGeocode = 0, Error = 0 WHERE CvcTransactionsLog_ID = 14
--UPDATE dbo.CvcTransactionsLog SET Geocoded = 0, ReadyToGeocode = 1, Error = 0 WHERE CvcTransactionsLog_ID = 14
SELECT TOP 5 * FROM dbo.Unica_Raw_Data_01
SELECT * FROM dbo.Unica_Data ud (NOLOCK) WHERE
I think this is the same issue that someone else has reported: http://www.red-gate.com/MessageBoard/viewtopic.php?t=9407&highlight=nolock
The where clause at the bottom is failing to show anything releveant in the window that comes up. It's showing only system functions. If I type UD. I get options like 'alter table' snippet - it doesn't seem to know it's on a select statement at all.
BUT - if I remove the (NOLOCK) it starts working. So there you go - (NOLOCK) is causing where clause prompts to fail.