Hi All,
In profile,We always see such infomation
"exec sp_execute 1, N'A001', N'A001'"
But who can tell me how to get out the prepared sql for "1",
Thanks.
Look at the stmts before that one, you should be able to see one that says
something like
declare @.P1 int
set @.P1 = 1
exec sp_prepexec @.....
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"wy" <wy@.juyee.com> wrote in message
news:%230YWAJgSEHA.3812@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> In profile,We always see such infomation
> "exec sp_execute 1, N'A001', N'A001'"
> But who can tell me how to get out the prepared sql for "1",
> Thanks.
>
|||The event log is too large,and I can't find the stmt just before that
one,because the stmt may prepare far away from that one.
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:uETFSfgSEHA.3844@.TK2MSFTNGP11.phx.gbl...
> Look at the stmts before that one, you should be able to see one that says
> something like
> declare @.P1 int
> set @.P1 = 1
> exec sp_prepexec @.....
> Peter Yeoh
> http://www.yohz.com
> Need smaller backup files? Try MiniSQLBackup
>
> "wy" <wy@.juyee.com> wrote in message
> news:%230YWAJgSEHA.3812@.TK2MSFTNGP11.phx.gbl...
>
|||How about using the Find feature in Profiler?
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"wy" <wy@.juyee.com> wrote in message
news:uB5AyaiSEHA.3872@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> The event log is too large,and I can't find the stmt just before that
> one,because the stmt may prepare far away from that one.
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:uETFSfgSEHA.3844@.TK2MSFTNGP11.phx.gbl...
says
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment