Can't format the pseudo column %%physloc%%

ogrishman

There is an undocumented column in SQL Server called %%physloc%%. You can get more information from here at http://www.sqlskills.com/blogs/paul/sql ... -function/ It's undocumented but it's very useful sometimes. Right now SQL Prompt can't format scripts that have %%physloc%% in them. Not sure if you guys want to add the support to format it.

Thanks.

Rob C

Thanks for the suggestion! Would you be able to post it at our UserVoice site? That way other users will be able to vote on your suggestion if they would like to see it implemented.

torsten.strauss

Honestly I consider this as some kind of bug rather than a formatting enhancement.
I use the function a lot during presentation and whenever I need to reformat the entire code this function causes Redgate (and MS intellisense) to fail which will draw the attention of the audience to Redgate SQL Prompt in a negative way...
Despite of the fact that the function is not officially supported it would be nice to see the implementation in some of the next releases without the survey beforehand.

Many thanks for your support!