SQL Server 2005 - Auto-indent???

Hi,

I recently installed Sql Server 2005 SP1 and plan to use it going forward as my primary database engine. I'm creating my first SQL Server 2005 database - everything so far is going well and I really do like the improvements over 2000 as far as the tabbed interface goes...

First problem though ... I've just began to create a stored procedure, and am noticing that in the SQL Server 2005 T-SQL Query text editor, it does not auto-indent the next line of code for me when I enter a carriage return - i.e. it goes back to column 1, and I have to manually hit the Tab key several times for each line that I type to ensure my code is indented properly - like in Notepad!

I am appalled by this. Query Analyzer in SQL 2000 did not have this shortcoming. I cannot find an option anywhere in the Options dialog to "enable" it either. I am hoping this is a bug or error and not the intended design by microsoft.

Anybody have the same issue Am I missing something Can somebody confirm that this is the intended functionaly of the editor If so, is there some sort of plug-in for SQL Managemetn Studio that allows a more powerful T-SQL coding experience

Sorry for the rant, but I am very displeased and actually quite shocked.



Answer this question

SQL Server 2005 - Auto-indent???

  • Vincent Vouillon

    You may want to report this feedback in http://connect.microsoft.com so that the tools team gets it. I am also moving the thread to the SQL Server Tools forum so that any of the tools team members can file a bug for you or explain the behavior or provide workaround.

  • SQL Server 2005 - Auto-indent???