Re: How to tracking trigger
From: Thana N. (n-thana-n0reply_at_h0tmail.c0m)
Date: 02/17/04
- Next message: Eddie Baby: "Re: Reaching columns -in C#.net- in queries with multiple tables with the same column name"
- Previous message: Fred: "RE: isnumeric does not recognize decimal"
- In reply to: Uri Dimant: "Re: How to tracking trigger"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Feb 2004 15:41:08 +0700
Uri,
Is there anyway to track the historical for this? Because it is running on
the production and I cannot have a right to run Profiler for this (my sql
user is not in a group of sysadmin).
Thanks for reply,
Thana N.
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:ONJrz0S9DHA.2560@TK2MSFTNGP09.phx.gbl...
> Thana
> Run SQL Server Profiler to capture SP:StmtCompleted event.
>
>
> "Thana N." <n-thana-n0reply@h0tmail.c0m> wrote in message
> news:eDiBAnS9DHA.2412@TK2MSFTNGP09.phx.gbl...
> > Hi guys,
> >
> > I'm using trigger to write multiple files (5-6 file on multiple
> directories)
> > using xp_cmdshell (invoke echo "" > path) on SQL Server 2000.
> >
> > I've found that sometime it does not output all the files it should be
> > written (almost the last file). So I'd like to check what happen on my
> > trigger. Could you please suggest me?
> >
> > Thanks in advance,
> > Thana N.
> >
> >
>
>
- Next message: Eddie Baby: "Re: Reaching columns -in C#.net- in queries with multiple tables with the same column name"
- Previous message: Fred: "RE: isnumeric does not recognize decimal"
- In reply to: Uri Dimant: "Re: How to tracking trigger"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
