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.

Filter by
Sorted by
Tagged with
4
votes
3answers
1k 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 ...
0
votes
2answers
48 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 ...
4
votes
1answer
3k 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/...
0
votes
1answer
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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
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? ...
6
votes
2answers
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]::...