Capture Current SQL Statements

There must be an adhoc command to capture these statements, like they do in
profiler. Does anyone know how?
Thanks
See if these help:
Using fn_get_sql
http://vyaskn.tripod.com/fn_get_sql.htm
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_side...sql_server.htm
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"David" <David@.discussions.microsoft.com> wrote in message
news:149937CB-151C-4E52-A001-DA4D052C86AC@.microsoft.com...
> There must be an adhoc command to capture these statements, like they do
in
> profiler. Does anyone know how?
> Thanks
|||Vyas,
Do you think I can run server side tracing SP 24/7 for auditing purposes?
Thanks.
"Narayana Vyas Kondreddi" wrote:

> See if these help:
> Using fn_get_sql
> http://vyaskn.tripod.com/fn_get_sql.htm
> Automating Server Side Tracing in SQL Server
> http://vyaskn.tripod.com/server_side...sql_server.htm
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:149937CB-151C-4E52-A001-DA4D052C86AC@.microsoft.com...
> in
>
>