This is not a problem with SQL Prompt, at all, but I wanted to point it out to you, just so you know. SQL Server exposes some undocumented columns that can actually be useful. One of them is %%lockres%%. When I use this column in a query and try to format that query with SQL Prompt, it shows up as an error. Again, I understand why it would, but I thought you should know about it.
Grant Fritchey
0

Comments

1 comment

  • Anu D
    Many thanks for your post and your feedback regarding the product.

    I have logged this request on our internal tracking system whose id is SP-2942.

    It will be reviewed for a future release of SQL Prompt although we have no timescales for this at present.

    I will update you as soon as this functionality is incorporated.
    Anu D
    0

Add comment

Please sign in to leave a comment.