Nice and simple.

Thanks for sharing. Cool script.

You also might want to limit the data collection for only 'ONLINE' databases.

SELECT [name] FROM master.dbo.sysdatabases

WHERE DATABASEPROPERTYEX(name, 'status')...

For your viewing pleasures... here is another working sample tested on sql 8 - 10.50

IF EXISTS ( SELECT * FROM tempdb..sysobjects WHERE id =...

SS2K8 R2 Ent install on Win2K8 R2 Ent 64 bit hates me 😉

I give up, it is time rebuild the server from scratch :hehe:

nice little proc. thanks for sharing.

dwithroder: can you post the actual result for both inqueries... running on sql and wmi powershell.

RedGate's SQL Compare does the wonders 😉

The tool well worth every penny/shilling.

~Leon

Powershell rocks! Great tool for auditing and keeping eye on your server farm.

Good read. Must have script in every DBA's toolbelts.

Thanks for sharing

~Leon

I would not recommend this option unless you absolutely have to bring your SQL Server online within 1 hour to meet the SLA and simply reattach all your user databases...

Here is snippet of PowerShell script that returns some details like socets, cores, memory, and tells if it is VM or not (for only VMWare hosts).

$Servers = Invoke-sqlcmd2 -ServerInstance "<dbserver>"...

Nice way to make PoSh do the digging for ya. 😎

Great idea. Thkx. Does need just a little "fine tuning" to make it work as advertized on VLDBs.

😉

Great idea. Thkx. Does need just a little "fine tuning" to make it work as advertized on VLDBs.

😉

SSC party... to play pocker sql server style :w00t: