Xp_cmdshell is an
extended stored procedure that provides an environment analogous to a Windows
command shell and passes in a string for execution. Any output is returned as
rows of text. By using xp_ cmdshell, we can run many Window/DOS commands in SQL
Server environment. Some of the common DOS commands that can be run through
xp_cmdshell are COPY, MOVE, and RENAME etc. Use the below script to enable xp_cmdshell extended stored procedure:
extended stored procedure that provides an environment analogous to a Windows
command shell and passes in a string for execution. Any output is returned as
rows of text. By using xp_ cmdshell, we can run many Window/DOS commands in SQL
Server environment. Some of the common DOS commands that can be run through
xp_cmdshell are COPY, MOVE, and RENAME etc. Use the below script to enable xp_cmdshell extended stored procedure:
|