The intellisense feature in SSMS 2008 is great but alot of my old stored
procedure code uses local variables that start with 2 @ signs, e.g. @@index,
etc. This is valid syntax for the variables but SSMS 2008 highlights these as
errors. Is there any way to configure SSMS 2008 to recognize these?

David Morse (David Morse (AT) discussions (DOT) microsoft.com) writes:
No, it may be a known issue. I tested in various versions I have
available, and in the November CTP version of SQL 2008 R2 I don't
get red squiggles for names starting with @@. So if you are really
desperate, you could download the CTP and install SSMS from it. But
beware that installing beta software on your regular machine may cause
problems further ahead.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

This doesn't happen for me. What version of SSMS are you using? Have you
applied service pack 1 to your workstation?




On 12/15/09 2:14 PM, in article
883541F0-44B0-4EF3-8801-10D90D85A258...soft (DOT) com, "David Morse" <David
Morse (AT) discussions (DOT) microsoft.com> wrote:

Aaron Bertrand (moc.liamg (AT) dnartreb (DOT) noraa) writes:
I get red squiggles for

declare @@spig int

in SSMS 2008, but not SSMS 2008 R2.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

You're right, I think I tried to validate on a machine with the latest CTP,
not 2008 proper.



On 12/16/09 5:49 PM, in article Xns9CE3F273A381BYazorman (AT) 127 (DOT) 0.0.1, "Erland
Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote: