Think In Geek

In geek we trust

November 13th, 2008

Controlling the commands executed with xp_cmdshell on SQL Server 2005

SQL Server has a special extended stored procedure called xp_cmdshell. This procedure has a lot of power: it allows to execute any command line code on the machine hosting the SQL Server. Imagine you want to list all the files on C: on the SQL Server Windows host: you could write a T-SQL statement like […]