Formatting Views
Hi
I just spotted a funny (bug ??)
I created a view
CREATE VIEW dbo.[xxxx]
As
SELECT ...
Then 6 tables plus joins etc
when I was done I <Formatted SQL> ( or Cnt KY ) and all the statements Left justified despite my options saying otherwise
I comment out the Create View ... AS and try agian , all formats normally
I now uncomment the Create View and it all left justifies again
Strange
I don't use vies too often so I haven't noticed it , also I have just installed Windows 7 , (any known clashes?)
This is SSMS 2008 , sp1 windows 7 pro
I also checked in Vs2008 sp1 same behaviour
Any thoughts
Mike
I just spotted a funny (bug ??)
I created a view
CREATE VIEW dbo.[xxxx]
As
SELECT ...
Then 6 tables plus joins etc
when I was done I <Formatted SQL> ( or Cnt KY ) and all the statements Left justified despite my options saying otherwise
I comment out the Create View ... AS and try agian , all formats normally
I now uncomment the Create View and it all left justifies again
Strange
I don't use vies too often so I haven't noticed it , also I have just installed Windows 7 , (any known clashes?)
This is SSMS 2008 , sp1 windows 7 pro
I also checked in Vs2008 sp1 same behaviour
Any thoughts
Mike
Comments
This is a known issue and our development team is working on this.
I have added your comments to this issue whose unique identification is SP-2773.
I wanted to suggest a workaround for this issue until the bug gets fixed.
You can select the query except the 'Create View' or 'Alter View' statement and SQL prompt will format is as per your expectation.
Hope this will help you. Once again sorry for the inconvenience caused by this issue.
Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248
Please let us know if this fixes your issue.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com