These procedures import/export data to/from a single table using the OLE Automation functionality of SQL Server 6.5. The purpose is to give users the ability to work with data without giving them access to xp_cmdshell. The create and run this stored procedure you will need to create the stored procedures listed in the BOL under the topic “HRESULT Return Codes”

For SQL Server 6.5

Author: Buddy Ackerman

Download Script:


We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
“as -is”, without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose…

Disclaimer Continued

Back to Database Journal Home

Previous articleSQL Server Tuning Top 10
Next articlesp_oleexport70.sql

Latest Articles