March 9, 2006 at 9:43 am
I have trace set up on one of my servers and i am trying to capture what values gets inserted in a tabe when sp_insert_<table> proc runs. What i see in the trace is
Insert into <table> (col1,col2,col3,col4,col5,col6)
values @col1,@col2,@col3,@col4,@col5,@col6 . Is there a way i could see whats the values of these variables? what counter needs to be selected in events tab in profiler or is there any other setting that i need to take. Any help on this will be greatly appreciated.
TIA
March 13, 2006 at 12:35 pm
Think you'll need to use a log reader, or some other tool - maybe Teratrax ( one that I use ), it's not an easy thing to set up to test, sorry. I can't recollect having this problem - select all the sp events.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 2, 2006 at 9:31 pm
Set the profiler [ events ] to TSQL:Stmt Completed, and now you can observe the values of variables in the column [TextData] of Trace window.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply