Ole Automation Procedures (server configuration option)
Applies to:
SQL Server
Use the Ole Automation Procedures option to specify whether OLE Automation objects can be instantiated within Transact-SQL batches. This option can also be configured using the Policy-Based Management or the sp_configure stored procedure. For more information, see Surface Area Configuration.
The Ole Automation Procedures option can be set to the following values.
0
OLE Automation Procedures are disabled. Default for new instances of SQL Server.
1
OLE Automation Procedures are enabled.
When OLE Automation Procedures are enabled, a call to sp_OACreate will start the OLE shared execution environment.
The current value of the Ole Automation Procedures option can be viewed and changed by using the sp_configure system stored procedure.
Examples
The following example shows how to view the current setting of OLE Automation procedures.
EXEC sp_configure 'Ole Automation Procedures';
GO
The following example shows how to enable OLE Automation procedures.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
See Also
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)
Surface Area Configuration
Server Configuration Options (SQL Server)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru