Re: enable tracing from .NET application.

From: Matthias Hoys <anti_at_spam.com>
Date: Wed, 27 Dec 2006 22:10:07 +0100
Message-ID: <4592e12f$0$5526$ba620e4c@news.skynet.be>

"probashi" <probashi_at_hotmail.com> wrote in message news:1167246515.954933.173900_at_a3g2000cwd.googlegroups.com...
> is it possible to enable tracing from .NET application using the
> following:
>
> alter session set sql_trace = true
>
> PS: I am using ADO.NET 2.0 and Visual Studion 2005 and C#
>

Just execute the query before any other queries for the session you want to trace. I don't see the problem ?
You could also write a after-logon trigger which automatically enables session tracing for a specific login. Be aware that trace files end up on the database server (not the client) and can potentially fill up the filesystem.

Matthias Received on Wed Dec 27 2006 - 15:10:07 CST