|
|
Posted by Jeff Kish on 05/20/07 22:50
On Fri, 18 May 2007 20:45:24 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:
>Jeff Kish (jeff.kish@mro.com) writes:
>> is there a way using sqlexpress to review the most recent set of sql
>> commands submitted to a database?
>> I remember something about setting up logging in sql server 2000, but
>> don't see much about this on google or the news group for 2005.
>
>You could set up a server-side trace for this, look up the sp_trace_xxx
>functions in Books Online.
>
>The lazy way to run a trace is to use Profiler, but Profiler does not
>ship with SQL Express. Then again, longer tracing in production systems
>is best done with server-side traces as they take less resources. Yet
>then again, it's convenient to have Profiler, as you can define the
>trace in Profiler and then export the trace definition as an SQL script.
Oh thanks.
I have sql server 2000 also on the machine, however I'm trying not to use it
as 2005 is the preferred microsoft platform for db's.
i'll check out the online books.
thanks much
Jeff Kish
Navigation:
[Reply to this message]
|