Skip to content

Instantly share code, notes, and snippets.

@mattmc3

mattmc3/enable_ole.sql

Created April 6, 2017 14:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mattmc3/04eeb50c845ff0e1bc026ea181b0db52 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mattmc3/04eeb50c845ff0e1bc026ea181b0db52 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL - enable OLE
Raw
enable_ole.sql
exec sp_configure 'show advanced options',1;
go
reconfigure;
go
sp_configure 'Ole Automation Procedures', 1;
go
reconfigure;
go
sp_configure 'show advanced options', 0;
go
reconfigure;
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment