Formatting Views

MikeONeillMikeONeill Posts: 131
edited February 4, 2010 6:04AM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for the inconvenience caused by SQL Prompt.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your patience regarding this issue.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.