What are the challenges you face when working across database platforms? Take the survey

Undocumented Column

Grant FritcheyGrant Fritchey Posts: 72
edited March 29, 2010 11:32AM in SQL Prompt Previous Versions
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.


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.