@dezso Oops! Late night. Touch screen. Sorry! Maybe I should just have called him Eric?

@JackDouglas Which is why I wrote the message, trying to explain my motivation.

@JackDouglas Part of my "reject" vote: I'd didn't want x.10^n review tasks to suddenly materialise. Then again .. review badges .. tasty, shiny badges ... hmmmmm, badges

@MichaelGreen yes that would be a pain

@MichaelGreen that's a good idea

@ypercube isn't it suspicious that recursion is so easy?

@dezso yeah. ridiculously easy ;)

@ypercube I can hear the noise of systems crashing because of relying on this 'solution'

it's something to wonder how 1 or 2 people commented "yes, this is awesome and works" and upvoted and the crowd just followed.

The answer had +55-1 when I saw it.

licence issues?

theoretically from Thailand

could not imagine what a right click was, now I'm enlightened

@dezso Actually being used to ssis/visual studio that answer makes perfect sense

@dezso A "solution" may be a type of object in VS, kind of like a project group, I think. When I close SSMS with several unsaved query windows, it asks me whether I want to save my stuff, showing a mini-tree the root item of which is typically "Solution1" followed by leaves like "SQLQuery1", "SQLQuery2" etc.

not that it will solve the problem, i think

I couldn't understand that answer either

The wording seems recursive:

Yes, the two meanings definitely clash there, no wonder people are confused.

@TomV that explains a lot

@dezso "solution" is just a level above "projects" in the "solution explorer" pane

@TomV I've added a comment there, please improve on it, if needed

@dezso I think that should be clearer now

@TomV great, I've removed my comments

does anyone see any reason to not use xp_fixeddrives to determine what drive letters are available to SQL Server 2005+ ? I don't see it as deprecated; however since it is an undocumented feature, that doesn't surprise me.

@MaxVernon not much, no, except it doesn't show you the original space, only the free one

@Marian thanks. I'm only interested in the drive letters SQL Server uses for databases\logs

@MaxVernon you'll have to filter that, unfortunately

@Marian I'm actually trying to ensure a certain database has been dropped, and it's files removed, in an automated fashion, using xp_cmdshell, so knowing all the drive letters SQL Server can "see" gets me most of the way there! Thanks for your help!

I'm also going to get some path info from the msdb backup-related tables.

@MaxVernon I tend to just use sys.master_files something like DISTINCT LEFT(physical_name,1). Just because you can more easily do something with that data, versus the XP you have to dump to table and all that.

@ShawnMelton lol, I'm using a cursor to run xp_cmdshell on each drive letter multiple times looking for a known path using DIR /b /s kind of thing, so in this case I actually need the temporary table anyway. I should probably be doing this in PoSH.

@MaxVernon that's bèèèèd

@TomV looool

@MaxVernon Or just call Posh in your xp_cmdshell, would likely be more efficient that the dos prompt DIR.

@ShawnMelton maybe.... although xp_cmdshell loads cmd.exe which contains the dir function natively anyway, so maybe not.

PowerShell contains dir natively as well

xp_cmdshell would still have to load cmd.exe, and then load ps.exe

You might also do this quicker in SQL CLR...if you wanted to dig that whole.

That's a pretty big hole for what I need to do.

:)

I used xp_cmdshell and PowerShell to build out storage monitoring and reporting for customer few years ago. It worked out pretty well, not sure using Posh to search directories would compare to just native command with DOS.

I bet you have a lot more functionality in the PoSH version, which might be nice depending on requirements.

@MaxVernon I was holding on to old habits but have entirely switched to powershell and I'm so loving it

I come from a *nix background and found cmd.exe extremely lacking, but POSH is killing bash and off course cmd

gotta love ls for that.

I was typing, "ls would do that without worries" :)

@TomV not that my *nix skillz are that great, but I regularly use AIX here so I'm getting better at it.

on another note entirely, Windows 10 Mobile on my Lumia 950 XL is a bit on the "beta" end of things. Plus, no "Here Drive+", which really bites. On a positive side, Microsoft is shipping me a free Display Dock which should be here next week so I can try out Continuum.

I must say wireless charging is great! Not having to plug in the phone is far sweeeeter than I imagined it would be.

I have a lumia, best thing is, dynamics AX 7 is cloud based, works on every phone except WP

@TomV I wonder if it works with the Edge browser on Windows 10 mobile?

@MaxVernon 11(+) so probably

@Lamak Hope you're safe.