Check out the articles in my signature on Cross-Tabs / Pivot tables, Part 1 and 2. Part 2 delves into dynamic solutions, which sounds like what you would need.

You might want to try http://www.ssmstoolspack.com

Jeff, you might be able to use this article[/url] to do it.

Also, can you get this information if you were to use xp_cmdshell? You could enable/disable that just like...

Good Luck in them letting you actually leave! :crying:

Seriously, best of luck in...

Thanks for the update Jeff.

In 2008, you should be able to use PowerShell to get the data you need.

A "CTE" (Common-Table-Expression) is essentially a pre-defined sub-query. It starts with the keyword "WITH", followed by the...

Ricardumus (8/4/2010)

---

Wow, that looks awesome.

What does it do? lol

Honestly you blasted way past me with your SQL knowledge. You went to the moon and

im still stuck in Rhode...

jeff.mason (8/5/2010)

---

Don't have a ton of experience mapping COM object to VBScripts, so at first I am not sure how to do this with the OA procs, but you don't...

How about simply:

execute sp_MSforeachdb 'IF ''?'' NOT IN (''model'',''master'',''msdb'',''tempdb'',''ReportServer'',''ReportServerTempDB'') BEGIN PRINT ''Checking Database ?'';DELETE FROM [?].dbo.WORKLISTLOG;END;'

Note: those are all single-quotes...

@Lowell: while you're in a learning mode, did you know that you can add "Places" to your SSMS open/save dialogs?

For SQL 2008 (for 2005, substitute 90 for 100 below):

Windows Registry...

Sounds like a dynamic cross-tab / pivot. See the two articles in my signature (Parts 1 and 2) - part 2 covers a dynamic cross-tab.

Can you get the mount point information from VBSCRIPT? If so, then you should be able to just expand upon what is already there with the sp_OA calls. I've never...

Back to the original question...

How does this work for you? (It might need some adjustment if running on a Sunday, but you should be able to work that out. If...

Lowell (8/5/2010)

---

WayneS (8/5/2010)

---

If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.

If it's a...

Not sure if this will get the mount points. This method requires ole automation be on. It turns it on, and then returns it to it's original setting when finished.

IF...