xp_cmdshell (Transact-SQL) - SQL Server

Applies to: SQL Server

Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows of text. Transact-SQL syntax conventions

xp_cmdshell { 'command_string' } [ , NO_OUTPUT ]

Important

Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.

The string that contains a command to be passed to the operating system. command_string is varchar(8000) or nvarchar(4000), with no default. command_string can't contain more than one set of double quotation marks. A single pair of quotation marks is required if any spaces are present in…