Unanswered: sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload' in 2005
With my Sql server I install SQLxml3.0 and run this with problem.
I plan to go with the Sql server 2005 but this code give me a error...
DECLARE @ObjectError INT
, @Object INT
, @ErrMsg VARCHAR(50)
EXEC @ObjectError = sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload', @Object OUT,4
My user right not change. And I dont see some "SQLXML" in the "Surface Area Configuration"???
Msg 15281, Level 16, State 1, Procedure sp_OACreate, Line 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online.
Can someone can give my suggestion?