@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
@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.
I edited your comment to make it a bit more clear, but I don't see how that property would have an impact on the generation of packages from BIML. It would be nice if you could add some information on 'how' your solution would work for the OP — Tom V8 secs ago
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.
@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.
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.
@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.