How to log SQL output to text file on client from C#

Posted by Rob Packwood on Stack Overflow See other posts from Stack Overflow or by Rob Packwood
Published on 2010-05-12T18:36:42Z Indexed on 2010/05/12 18:44 UTC
Read the original article Hit count: 136

Filed under:
|

I have a large auditing stored procedure that prints values and runs some SELECT statements. When running within SQL Management Studio we have the use select to display "Results to Text" so all of the SQL results and print statement display in one place.

Now I need to have some C# code also call this auditing procedure at the end of the process and basically store all data that would be in the "Results to Text" window into a .txt file.

How can this be done?

© Stack Overflow or respective owner

Related posts about c#

Related posts about sql-server