How to Enable xp_cmdshell in SQL Server 2005/2008?

The built-in extended stored procedure xp_cmdshell is very much needed for DBA and Developers. By using this extended stored procedure we have the ability to run the Command line utilities/process. We can use this extended stored procedure in Stored Procedures and Job Schedules.

How to enable xp_cmdshell?

sp_configure ‘xp_cmdshell’, ‘1’

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: