Home Forums SQL Server 7,2000 T-SQL How to write query result in an output file in T-SQL (MSDE) RE: How to write query result in an output file in T-SQL (MSDE)

  • November 21, 2007 at 8:14 pm

    #753267

    Hi Carl,

    I already redirect the result to file using osql (whithin a stored proc and xp_cmdshell ) or using sp_OACreate 'Scripting.FileSystemObject' and it works fine.

    The problem is littlesquall can not use the 2 methods because of security constraints (The network admin does not allow)

    Regards,

    Ahmed