Server-Side Trace in CLR Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Design Ideas and Questions » Server-Side Trace in CLR Stored Procedure

Server-Side Trace in CLR Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

cwfongwork

Posted Monday, September 20, 2010 12:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 17, 2013 6:44 PM
Points: 2, Visits: 127

For application debugging purpose, we are designing for a trace feature to capture all application related SQL batches and debug messages on a SQL Server Instance. Exporting the trace is also required.

We run SQL batches and write the debug messages all within CLR Stored Procedures.

We are considering to
- Write code to insert trace records into database table.
- Use SQL Trace T-SQL.

Which do you think is usual practice and better? Or could you see any another approach?

Thank you.

Post #989139

« Prev Topic | Next Topic »

Permissions