Hi Lowell,

Thanks for the sample script 😀

Let me ask one thing?...using the sample script you gave me how it will be used? I mean is like, for example i have...

Hi Lowell

Thanks for a quick response, Actually my main goal here is I have two database in where it can be place in the same server (what we call a...

So what do you think is the best way to handle my issue? I know you have a lot of experience than mine? so i think i need your help...

Yup this code is in the trigger. I know this scripts is more efficient but i need to loop it to avoid the transaction context is in used by another...

The error is transaction Context is used by another session....

Yup it allow remote connection..

Hi Guys,

I already resolve my issue with the tablediffutility

This tool is so great!thanks for sharing it with me

MwaaaH

Thank you guys,

I download a the said utility but i ot the following error.

" Invalid object name 'dbo.tblsmpreferenceuser'."

Hi Rookie

Yup You Are right this site is so great and fantastic..it help the programmer a lot in analyzing and in some tricks on how to handle certain scenario using...

Wow yes you are right there is a huge difference between the two...Thanks to both of you....Thanks a lot i already revised my script:-D thanks a lot guys you are...

Hi SSC Rookie

You save my day!...

Great!

You gave me a solutions at the same time i learned from that:hehe:

Thank you so much;-)

Thanks,

Attached to this reply is a sample screen shots of my table structure, Hope it will help you a lot.

Thanks so much

Hi flo,

Thanks for the time it's an odd thing but believe me when i do that like what you have said the Update statement works. But in the trigger it...

Thanks,

Yup i do check the value of the variable and it seems that they are correct, i suspect that there is some thing wrong with my join but i can't...