I have question about usage of this SP that how legal it is use to use this sp?
what kind of impact it does on your sever when a statement with this sp is fired? I mean does it have any negative impacts on using this SP, since it comes under undocumented SPs.
There are no legal implications for you to use it, it is an undocumented stored procedure, which basically means we built it for our use and we don't want to support it for YOURS. So if you use it and it stops working the way you want or it previously had then TOUGH. The only thing even remotely legal about it comes down to you can't complain and have no legal position if you use it and it stops working for you.
As far as performance it is pretty marginal, considering what it is doing.. The statement YOU pass in to execute is much more likely to have a performance impact than it itself.