-------------------------------------------------------------------------------------
-- Enable  Ole Automation Procedures
-------------------------------------------------------------------------------------

EXEC master.dbo.sp_configure  'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC master.dbo.sp_configure  'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

-------------------------------------------------------------------------------------
-- Enable  xp_cmdshell
-------------------------------------------------------------------------------------

EXEC master.dbo.sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

-------------------------------------------------------------------------------------
-- Enable  CLR
-------------------------------------------------------------------------------------

EXEC master.dbo.sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC master.dbo.sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO