Undocumented Column

Grant Fritchey

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.

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.