"N" <N@N.COM> wrote in message news:<17*****************@newssvr25.news.prodigy.c om>...
Hi ,
Is there a way/tool in Sql Server 2000 SP3 to
monitor all activities going on in the Database ?
For example, I first create an empty database.
Then I have an ERWIN generated DDL to create
all views and tables. After that, I have INSERT
scripts that populate all the base tables. What I
want to monitor is success or failure for each
script.
Thanks,
N.
You can use Profiler to view all SQL being sent to the database, but
it sounds like you want to add error handling to your scripts? How to
do that would depend how you run the scripts - eg. if you're using
osql, then -r might be useful. Perhaps if you can give some extra
information about how you call the scripts, and an example of the
code, then someone may be able to suggest something specific.
Simon