Help setting up a trace for a sp

Hello,
I haven't really used the trace program much. I am having a problem with
a sp that we created it seems to skip records during the cursor. I want to
setup a trace on that specific store procedure only is there a way to do
this? Thanks in advance. The name of the sp is called "datacollection"
JakeI'm a little confused as to what you want to trace. Would you explain
more? Sounds like you want to trace the progress through a SP. Meaning you
want to show every command it executes? Sounds like you what you want to do
is use the Transact-SQL debugger. Is this correct? I have not used the
T-SQL debugger, so I really can't help you if this is what you are looking
for. But here is an msdn article that might get you started:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconthetsqldebugger.asp
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jake" <rondican@.hotmail.com> wrote in message
news:O7WS7hTWEHA.2940@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I haven't really used the trace program much. I am having a problem
with
> a sp that we created it seems to skip records during the cursor. I want to
> setup a trace on that specific store procedure only is there a way to do
> this? Thanks in advance. The name of the sp is called "datacollection"
> Jake
>|||Gregory,
I was looking at the profiler tool that comes with SQL. You are correct
in that I want to see each line being processed for the sp. I will take a
look at this and see if I can tweak it to work for our needs. Thanks.
Jake
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:O3SQ8uTWEHA.3012@.tk2msftngp13.phx.gbl...
> I'm a little confused as to what you want to trace. Would you explain
> more? Sounds like you want to trace the progress through a SP. Meaning
you
> want to show every command it executes? Sounds like you what you want to
do
> is use the Transact-SQL debugger. Is this correct? I have not used the
> T-SQL debugger, so I really can't help you if this is what you are looking
> for. But here is an msdn article that might get you started:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconthetsqldebugger.asp
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Jake" <rondican@.hotmail.com> wrote in message
> news:O7WS7hTWEHA.2940@.TK2MSFTNGP09.phx.gbl...
> > Hello,
> >
> > I haven't really used the trace program much. I am having a problem
> with
> > a sp that we created it seems to skip records during the cursor. I want
to
> > setup a trace on that specific store procedure only is there a way to do
> > this? Thanks in advance. The name of the sp is called "datacollection"
> >
> > Jake
> >
> >
>|||You might also want to review the "Transact-SQL Debugger Window" topic in
BOL.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jake" <rondican@.hotmail.com> wrote in message
news:OM8ThzTWEHA.1048@.tk2msftngp13.phx.gbl...
> Gregory,
> I was looking at the profiler tool that comes with SQL. You are
correct
> in that I want to see each line being processed for the sp. I will take a
> look at this and see if I can tweak it to work for our needs. Thanks.
> Jake
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:O3SQ8uTWEHA.3012@.tk2msftngp13.phx.gbl...
> > I'm a little confused as to what you want to trace. Would you explain
> > more? Sounds like you want to trace the progress through a SP. Meaning
> you
> > want to show every command it executes? Sounds like you what you want
to
> do
> > is use the Transact-SQL debugger. Is this correct? I have not used the
> > T-SQL debugger, so I really can't help you if this is what you are
looking
> > for. But here is an msdn article that might get you started:
> >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconthetsqldebugger.asp
> >
> >
> > --
> >
> ----
> --
> ----
> --
> > --
> >
> > Need SQL Server Examples check out my website at
> > http://www.geocities.com/sqlserverexamples
> > "Jake" <rondican@.hotmail.com> wrote in message
> > news:O7WS7hTWEHA.2940@.TK2MSFTNGP09.phx.gbl...
> > > Hello,
> > >
> > > I haven't really used the trace program much. I am having a
problem
> > with
> > > a sp that we created it seems to skip records during the cursor. I
want
> to
> > > setup a trace on that specific store procedure only is there a way to
do
> > > this? Thanks in advance. The name of the sp is called "datacollection"
> > >
> > > Jake
> > >
> > >
> >
> >
>