dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 4, 2000

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Use for sp_OAStop

Question:
I noticed that MSDN contains sp_OAStop, which shuts down the OLE environment that starts inside SQL Server the first time you call sp_OACreate. But I can't figure out what sp_OAStop is good for, except that maybe using OLE Automation consumes resources that could be freed by calling sp_OAStop.

Please tell me any more about this. Will using sp_OACreate slow down my server? Should I call sp_OAStop at the end of any stored procedure that uses sp_OACreate?

Answer:
The sp_OAStop procedure shuts down the OLE automation execution environment. I can't think of a time that you'll need to call this unless you're doing server troubleshooting, because all the clients that use the OLE automation stored procedures share that environment.

I don't know the exact resource usage of these stored procedures but if you have appropriate server hardware it seems unlikely that these procedures would call problems with resources. Even if you call sp_OAStop the next time sp_OACreate is called, the execution environment restarts. Additionally, if sp_OAStop is called and any clients are in the process of issuing OLE automation statements they'll receive an error

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date