Tuesday, 7 January 2014

Script to enable OLE Automation in SQL Server




Below scripts are used to enable OLE Automation procedures in SQL Server.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE WITH OVERRIDE;

GO

EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE


GO