Use Port # 587 instead of 465. Also use SSL and you need to enter your gmail account info while configuring the DB mail using gmail. Enter your both account...

Thanks Wolfgang Lengenfelder. worked like a charm.:)

try this link..might help

http://support.microsoft.com/kb/272093

as far as i know you can't use different tables for computed column. columns has to be in the same table as per microsoft:

computed_column_expression

Is an expression that defines the...

in last 2 queries if you remove where clause you will get same result in all 3 queries. I tried and it worked fine.

Download VMWare, one of the versions is free, and then you can install XP Pro if you have installation CD and then you can install both SQL 2000 and 2005...

using SSIS.

True. I have been answering the questions for quite some time.;)

Thanks Jack. Looks like info you provided give me good insight.

Thanks again.

Thank You much Jason.

Thanks for the quick reply.

Thanks John.