> I'm working with an application that is associated with about 500
> stored procs.  I've discovered that some of the procs found in the
> application (VB.net) code do not exist in the database, and some of the
> procs in the database are not referenced in the VB code.
>
> The application mostly works, so, for example, I can successfully do an
> update transaction that successfully deposits the correct data in the
> correct tables.  Is there any way I can monitor (to a log file) which
> stored procs this transaction calls?  If there were only the one
> transaction, I'd simply trace through it and get them that way, but
> there are lots of them and I'd like to identify the stored procs
> without spending days pressing F11.
>
> In addition to enterprise manager, query analyzer and visual studio,
> I've got dbArtisan (v7) which has a monitor that does in fact show
> currently executing SQL for a session, but does not appear to have a
> way to log a session's activity.
>
> Any help would be most appreciated.
>
> Brandon
>

> redwoodt***@gmail.com wrote:
> > I'm working with an application that is associated with about 500
> > stored procs.  I've discovered that some of the procs found in the
> > application (VB.net) code do not exist in the database, and some of the
> > procs in the database are not referenced in the VB code.
> >
> > The application mostly works, so, for example, I can successfully do an
> > update transaction that successfully deposits the correct data in the
> > correct tables.  Is there any way I can monitor (to a log file) which
> > stored procs this transaction calls?  If there were only the one
> > transaction, I'd simply trace through it and get them that way, but
> > there are lots of them and I'd like to identify the stored procs
> > without spending days pressing F11.
> >
> > In addition to enterprise manager, query analyzer and visual studio,
> > I've got dbArtisan (v7) which has a monitor that does in fact show
> > currently executing SQL for a session, but does not appear to have a
> > way to log a session's activity.
> >
> > Any help would be most appreciated.
> >
> > Brandon
> >
>
> You can use SQL Profiler for this...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com