How to tracking trigger

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.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.
>|||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.
> >
> >
>

How to tracking trigger

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.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.
>|||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...
> directories)
>

How to track db growth over a period of time

Hello All
Can anyone tell me how I would go about tracking the database/data table
growth over a period of time
thanksHave a look at http://vyaskn.tripod.com/track_sql_...file_growth.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>|||"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
One source of this information is the SQL Server log files (not related to
transaction log files). Each time a backup occurs, the size in blocks (1
block = 8192 bytes) is written to the log file. These files are just text
files which are usually stored somewhere under the SQL Server installation
directory and have names like ERRORLOG.x.
Regards,
Simon

How to track db growth over a period of time

Hello All
Can anyone tell me how I would go about tracking the database/data table
growth over a period of time
thanks
Have a look at http://vyaskn.tripod.com/track_sql_d...ile_growth.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
|||"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
One source of this information is the SQL Server log files (not related to
transaction log files). Each time a backup occurs, the size in blocks (1
block = 8192 bytes) is written to the log file. These files are just text
files which are usually stored somewhere under the SQL Server installation
directory and have names like ERRORLOG.x.
Regards,
Simon

How to track db growth over a period of time

Hello All
Can anyone tell me how I would go about tracking the database/data table
growth over a period of time
thanksHave a look at http://vyaskn.tripod.com/track_sql_database_file_growth.htm
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>|||"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:e3nU3Zk$EHA.3424@.TK2MSFTNGP11.phx.gbl...
> Hello All
> Can anyone tell me how I would go about tracking the database/data table
> growth over a period of time
> thanks
>
One source of this information is the SQL Server log files (not related to
transaction log files). Each time a backup occurs, the size in blocks (1
block = 8192 bytes) is written to the log file. These files are just text
files which are usually stored somewhere under the SQL Server installation
directory and have names like ERRORLOG.x.
Regards,
Simon