Line up commands in Mgt Studio 1

[JayKusch]

I know I have toggled it on in the past but where do you set Mgt Studio to show you how your commands line up?

In other words, If I use an IF\ELSE statement I want to be able to highlight the IF and it shows me the corresponding ELSE further down in the code.

Thanks!


Thanks

J. Kusch

 

[SQLBill]

Right click in the query window and select Connection. That should give you the option to Connect your query.

However, for me it's working in SS2008, but not in SS2005 for some reason.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLBill]

My mistake...that's not it...

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[JayKusch]

Just the reverse for me ... works in 05 (some setting I hit quite a while back) but not in 08R2.

Trying to hunt down where its set at.

Thought it was a part of IntelliSense.

Thanks

J. Kusch

 

[SQLBill]

It is Intellisense - it's the feature 'syntax pair matching'. It works fine for me in SS2008, but I can't find a way to turn in on in SS2005. It's not even working when I do a query in SS2008 for a SS2005 server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLBill]

Just found this in the SS2008 BOL: Intellisense is only available when the Database Engine Query Editor is connected to an instance of the SQL Server 2008 Database Engine. IntelliSense is not available when the Query Editor is connected to earlier versions of the Database Engine.

And:
IntelliSense is turned off in the Database Engine Query Editor when the SQLCMD mode is set on.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[JayKusch]

Bingo!

Thanks Bill

Thanks

J. Kusch

 

[SQLBill]

Jay,

Could you have been taking advantage (using) a product like Red Gate's SQLPrompt?

Reason I ask is this from Microsoft:

IntelliSense was added in SQL Server 2008, so it's not a feature of SQL Server 2005. There are third party applications available, however, such as Red Gate's SQL Prompt that can be added into SQL Server Managment Studio 2005 to provide very similar features to those available in SQL Server Managment Studio 2008.

Ref:

http://msdn.microsoft.com/en-us/library/ms173434(SQL.90).aspx

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875