Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_executesql ?

Status
Not open for further replies.
Tomi

Tomi

Programmer
Nov 19, 2001
57
US
When I use dbcc inputbuffer for a spid it only mentions as - sp_executesql;1.How can I find the actual query involved?
In profiler do I need to select some specific events & columns for this ?

Thanks
Tomi
 
Sort by date Sort by votes
Hi,

Try using the "SQL:BatchCompleted" Event and it should show the T-SQL used along with the NT user etc?

These events are all part of the default trace template.

Hope this helps,

Cheers,
Leigh

You're only as good as your last backup!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BikeBoy20032004
  • Locked
  • Question
SP_EXECUTESQL or EXEC(@SQL)
Replies
2
Views
82
BikeBoy20032004
BikeBoy20032004

Part and Inventory Search

Sponsor

Back
Top