Guys,
Goodnight.

Today I will teach you how to enable OLE Automation features in SQL Server. For those who are not familiar with this feature, it allows the DBA or Developer to perform a series of actions on the database using OLE DB, such as reading/writing/moving/copying/deleting files, creating spreadsheets in Excel and a series of other things. The syntax is a little similar to VBA and uses the Windows API for these operations.

However, DBA, keep in mind that this can be a very useful and powerful tool for the IT team, but at the same time, a great risk to the security of your database, since users who will have access to these resources will be able, for example, to view or remove files from the database server itself or even from other machines on the network in an undetectable way.

To enable this feature, we use the commands below:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE;
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

Find out more:

That's it folks!
Soon I will post a post with some cool functions using OLE Automation. (Edit: Access the created post)