Still having some challenges folks -- maybe it would be better to explain what I am trying to accomplish.

I am trying to capture the value from an output...

Yes I am talking SSIS -- could you walk me through how you would set a watch on the variable?

Thanks

thanks for your response -- I have been playing around with the tool and your right using the filters is the way to remove items from the trace. It...

Your awesome dude -- Thanks sooooo much!!!

Actually my mistake this does work on temp tables but it does not work on variable tables nor does the drop table command. i.e.

declare @t1 table

(

c1 varchar(10)

)

insert into @t1 values('chess')

select...

Excellent explanations especially the logging behaviour of both commands. I was hoping I would have saw some details on the behaviour of these commands on temporary tables. Feel...

Forgot to say -- Thanks

How do you do this?

Hi Kenneth,

Yes this is correct but if you were to write some code like this

declare @p

declare @p

and then run it an error like this would be generated when parsing...

That's what I was thinking as well thanks for the confirmation.

Thanks Ray

Thanks Steve:)

Hi Lynn,

Sorry I may not have been very clear I was in a rush when I posted this. I am more concerned with the efficiency of using the...

Thanks everyone, especially Jeff M. was not aware of this tool

This is the code I used which works but can anybody offer suggestions to adjust this code to identify only key fields with a specified name?  Here is my code:

Select...