SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

OLE Automation Stored Procedures (Transact-SQL)

Object Hierarchy Syntax (Transact-SQL)

sp_OACreate (Transact-SQL)

sp_OADestroy (Transact-SQL)

sp_OAGetErrorInfo (Transact-SQL)

sp_OAGetProperty (Transact-SQL)

sp_OAMethod (Transact-SQL)

sp_OASetProperty (Transact-SQL)

sp_OAStop (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

OLE Automation Stored Procedures (Transact-SQL)

SQL Server 2005

Microsoft SQL Server 2005 supports the following system stored procedures that allow OLE automation objects to be used within a Transact-SQL batch.

sp_OACreate	sp_OAMethod
sp_OADestroy	sp_OASetProperty
sp_OAGetErrorInfo	sp_OAStop
sp_OAGetProperty	Object Hierarchy Syntax (Transact-SQL)

Reference

System Stored Procedures (Transact-SQL)

Other Resources

Ole Automation Procedures Option
Surface Area Configuration

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.