Code Collapse feature

[PaMcD]

Is there any option to turn back on the code collapse icons(+ and -) at the side on my scripts?

i can see the document outline feature, but its not exactly what i want to use, as its unclear what select statement does what. beforehand i could put a comment right above the select statement so when it was collapsed i could see a summary of what it does.

anything similar to this i can use?

[alexa]

In case you were referring to the 'Outlining' feature of dbForge Studio for SQL Server, it can be turned on by selecting 'Edit -> Outlining -> Start Automatic Outlining' from the main menu.

If you would like this feature to be turned on by default, please perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Text Editor -> Advanced' section.
3. Select the 'Enter outlining mode when files open' option.

[PaMcD]

Sorry I meant to say I'm using dbForge SQL Complete.

[alexa]

This is the setting of SSMS itself that can be turned on as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Text Editor -> Transact-SQL -> IntelliSense' section.
3. Select the 'Outline statements' option.

[PaMcD]

Thanks Alexa, that works now.

there isnt any issue with having intellisense and sql complete enabled at the same time is it?

[alexa]

That's fine. dbForge SQL Complete overrides the native intellisense of SSMS.