|
Home > Archive > MS SQL Server > November 2006 > Query history?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Rick Bond 2006-11-29, 5:17 am |
| Does SQL server keep track of all queries that are run by any chance?
Thanks
*** Sent via Developersdex http://www.droptable.com ***
| |
|
|
| Hari Prasad 2006-11-29, 7:12 pm |
| To add on to Tibor;
Profiler is littile bit resource intensive; so you will have to monitor the
server resources utilization while you run profiler. I wil not recommend to
run profiler
round the clock on a production server.
Thanks
Hari
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:OsZJXq4EHHA.924@TK2MSFTNGP02.phx.gbl...
> Nope, you'd have to do that yourself. Using Profiler, for example.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Rick Bond" <nospam@amen.com> wrote in message
> news:eTk98T4EHHA.4016@TK2MSFTNGP02.phx.gbl...
>
>
| |
|
|
|
|
|