Technical Article

Bulk Insert WMIC output to table w/ xp_cmdshell

This is an example of retrieving WMIC results using the xp_cmdshell proc, and inserting the results into a table.Specifically, this script retrieves disk info from the LogicalDisk class, but WMIC provides thousands of other properties. WMIC does require it be ran from a Windows 2003 server, but can query other Windows 2000 servers when executed […]

(1)

You rated this post out of 5. Change rating

2006-08-04 (first published: )

813 reads

Blogs

Self-Hosting a Photo Server the Whole Family Can Use

By

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Start with the FabricTools PowerShell module

By

Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...

Enterprise AI Operating Rhythm – Top 5 practices for 2026

By

2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...

Read the latest Blogs

Forums

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

By tedo

Comments posted to this topic are about the item SQL Art: I Made a...

lookup error

By [email protected]

I am using ssrs in visual studio 2022, I work on a report, there...

Visit the forum

Question of the Day

Celebrating Tomorrow

Which of these is more appropriate for tomorrow?

See possible answers