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. Msg 15281, Level 16, State 1, Procedure sp_OACreate, Line 1 Image 3: Result of Listing 5 BCP via CMD Window Results OLE object creation via SSMSĪs with using xp_cmdshell, this example requires that sp_configure is used to allow ‘Ole Automation Procedures’, otherwise a error message similair to the following will be raised: Make sure that you replace ‘ServerName’ and ‘InstanceName’ with values appropriate for your environment.īCP "SELECT PictureData FROM BLOB_ " QUERYOUT C:\BLOBTest\BlobOut\WC.jpg -T -f "C:\BLOBTest\FormatFile\BLOB.fmt" -S
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |