Questions tagged [ole-automation]
OLE Automation Procedures (i.e. sp_OA*) is a feature of Microsoft SQL Server that allows for calling OLE Automation objects and COM-visible code from within T-SQL batches.
10
questions
-2
votes
0
answers
31
views
Can OLE Automation Cause Big CXPACKET Waits?
I had two things running on my server at the same time.
An SSIS package that triggers a hungry but heavily parallel stored procedure
A terrible loop that calls entirely too much OLE Automation (e.g. ...
- 47
-2
votes
1
answer
96
views
Huge PREEMPTIVE_OS_GETPROCADDRESS Waits From sp_OAMethod. How to debug?
Some queries are hitting my CPU extremely hard. sp_WhoIsActive reports that sp_OAMethod is the cause (the sql_text column points to it) and that it has of huge waits of the ...
- 47
2
votes
1
answer
4k
views
What is the best way to export/extract varbinary images in a SQL Server database to flat file via t sql, anything better than sp_OA methods?
I've been tasked to extract images saved in SQL Server (as varbinary) to flat files via t-sql. I haven't done ETL work for over a decade and I can't recall any other method of doing this via t-sql ...
- 619
5
votes
3
answers
5k
views
What's an example of an exploitation of the security from enabling Ole Automation Procedures Server Configuration option?
I have a need to enable to the Ole Automation Procedures Server Configuration Option on my SQL Server, but was wondering what specific kind of security risks do I incur by doing so?
What is an ...
- 35.2k
0
votes
2
answers
54
views
Looking for recommendation [closed]
I am a non IT background, my recent projects uses PowerShell for a lot of SQL Server administration. I would like to start from absolute zero, and learn to use and code the Windows PowerShell as it ...
- 13
6
votes
1
answer
5k
views
When did sp_OACreate et. al. become deprecated?
I had an issue on an instance of SQL Server I'm supporting and many of the Stack sites have information on these features, but most of them basically say "Don't use those; they are deprecated/buggy/...
- 163
0
votes
1
answer
3k
views
Calling a web service from T-SQL (Stored Procedure) using MSXML [closed]
EXEC @hResult = sp_OAMethod @objectID, 'send', null, @requestBody
IF @hResult <> 0
BEGIN
EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT
SELECT ...
- 136
2
votes
2
answers
3k
views
Export a table and zip with password
I would like, from TSQL, to use a view to extract data from a table, output it with BCP, then use non 3rd party tools to ZIP it with a password and AES encryption. Optionnally, I could use a 3rd party ...
- 507
1
vote
1
answer
2k
views
Why do I see sp_OACreate, sp_OASetProperty in sp_WhoIsActive?
I've seen this happen a few times: sp_WhoIsActive shows various sp_OA% sprocs, with my user name, but I'm certainly not running them directly. Does this reflect some kind of query rewrite process? ...
- 5,957
6
votes
2
answers
2k
views
Can I call SMO from pure T-SQL?
I know how to script a stored procedure using PowerShell and SMO:
[System.reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null
[System.Reflection.Assembly]::...
- 12.2k