Phil Parkin (6/19/2015)
Alvin Ramard (6/19/2015)
Phil Parkin (6/19/2015)
Alvin Ramard (6/19/2015)
...If xp_DirTree won't do what you want, then you could use a VB or C# script to populate that same object variable.
In other words: "Rather than using a dodgy undocumented T-SQL hack, you could do it the proper way":-) This is better.
Phil, that's not what I meant to say, but you may be right. I just wanted to point out that there was an alternative.
On the subject of undocumented stored procedures, I've always wondered why they're undocumented if they're included with SQL Server. I can't help but wonder if they sometimes might have unexpected, or erroneous, results.
I've seen enough of your posts to know that you didn't mean it, or I wouldn't have responded like that 🙂
Those undocumented procs always seem to work and carry on working for me. It would be interesting to hear of examples of them changing in undocumented and unsupported ways.
Don't worry Phil. I've seen enough of your posts to that I understood what you meant. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]