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 […]

2 (1)

You rated this post out of 5. Change rating

2006-08-04 (first published: )

739 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

Backing Up Master

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up Master

Window Function Basics - PARTITION BY

By Emmitt Albright

Comments posted to this topic are about the item Window Function Basics - PARTITION...

Focus on Growth in Your Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Focus on Growth in Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers