블로그 이미지
Sunny's

calendar

« » 2025.1
일 월 화 수 목 금 토
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

Notice

'ole'에 해당되는 글 1건

  1. 2009.03.23 Ole Automation Procedures Option
2009. 3. 23. 13:06 MSSQL

Ole Automation Procedures Option


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 Understanding Surface Area Configuration.


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
posted by Sunny's
prev 1 next

티스토리툴바