Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Guest Columnist: Zach Nichter profile

   Items 1 to 1 of 1   

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.   Read more...
By Zach Nichter 2006/11/10 (first published: 2005/02/07) | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 34,067 reads
   Items 1 to 1 of 1