Formatting question

Our SQL style requires some items I am having trouble with.

We wrap the body of each stored proc in a begin/end pair and indent the body. I tried adding the begin and end to the formatting but the only way I could find to indent the body was to add a tab to each line of the formatting for each statement used in the proc. Is there a better way?

I am using SQL assistant 3.5 in SQL managements studio setup for SQL Server 2K.

Rob

You will not be able to do that in version 3.5. There are no options available in the formatting area to indent non-specific SQL statement. formatting is applied to SQL statements not to stored procedures or other types of multi-SQL programs.

On other hand it is sooo easier to indent the entire SQL script/program, by simply highlighting the program text and pressing Tab.

There will be a greatly enhanced formatting facility available in version 4, but I don't know whether it will be possible to apply formatting to SQL programs rather then SQL statements.