Comments
Sort by recent activity
Thanks for following up.
That would explain the inconsistent action I experience. I prefer to use SQL Prompt, so I will just turn off the SSMS. I did not think to check the SSMS intellisense, as I had not seen that particular action before I had installed SQL Prompt 5, so I made a bad assumption.
Thanks again,
Stephen / comments
Thanks for following up.
That would explain the inconsistent action I experience. I prefer to use SQL Prompt, so I will just turn off the SSMS. I did not think to check the SSMS intellisense, as I ...
No problem, let me know if you need any more info.
I was running SQL Prompt 4, I did an uninstall before installing the 5. I do not recall if I rebooted or not. :shock:
I can reproduce it with this script:
SELECT 'john' AS Fname, 'Jingle' AS Lname INTO #name
UNION
SELECT 'phil' AS Fname, 'Hart' AS Lname
SELECT * FROM #name AS N WHERE N.Lname = 'Hart'
--DROP TABLE #name
I noticed that the validation errors(red squibbles) return even after formatting, it was only temporary.
My local machine:
WinXP Pro Version 2002 SP3
Prompt:
5.0.0.365
SSMS:
10.0.2531.0
Connecting to SQL2008:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)
Here is the system info from SSMS:
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.1600.22
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3607
Operating System 5.1.2600
Thanks,
Stephen / comments
No problem, let me know if you need any more info.
I was running SQL Prompt 4, I did an uninstall before installing the 5. I do not recall if I rebooted or not. :shock:
I can reproduce it with this...