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:
sp_export65.sql
sp_import.sql
Disclaimer: 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
