How to Use XMLHTTP from within T-SQL (sp_oacreate)

Adam Machanic points out how to use MSXML2.ServerXMLHTTP.3.0 from within T-SQL using OLE objects. This is to perform different tasks.

However need to take into account that only members of the sysadmin fixed server role have permissions to execute sp_oacreate. Not to mention it is not database which should perform this kind of task. Hint - use higher layer component instead...

Related Posts:

• T-SQL Tip: How to Use GETDATE() in User Defined Function
• T-SQL: Search Logic
• T-SQL DATETIME : Last Day of the Month
• T-SQL trick: How to Know Record Row Number By Id Column
• How to Insert Millions Records into Database Table
• T-SQL: Update and Output in a Single Query
• MSSQL 2005 beta 2 DE first impressions
• MSSQL Overusability
• SQL Server 2005 Developer Edition Beta 2 (English)
• MSSQL 6.5 Service Pack 5 is Available