try to do odbcping if that helps.

i try to post earlier but some how it didn't get posted, so re-doing again.

check the cross domain trust between SQL Service account & that user account, arethey under same...

If you are going to replicate same articles to Server 'C' which you are replicating now to Server 'B' then Right click on publications & click on  "Push New Subscriber"...

What is the total MEMORY on the Server & say if it is 4 GB then use switch /3GB /userva = 3000 in boot.ini file.

i hope this info may help

Look for Data Type Precedence in BOL & that will help you.

I agree to brian kelly about having cross domain TRUST & that will save time.

OK, so still SQL 2005 is lacking with ARRAY datatype that will be my conclusion. As my Web Application is going to send list of string arrays so if i...

will try & update you , thanks for your help & time.

Let me see that if this logic works & will update accordingly. once again thanks for your time & help.I appreciate that.

Table "B" is empty but as all constarints like COL1 is Identity & PK. Alsi i have Table "C" which as Identity column & FK reference Table "B". So i...

Table "A" as 20 columns & some are Char & Varchar. Table "B" as 7 columns including COL1 as Identity & PK.

There is also Table "C" which as 7 columns...

Thank you very much for your all response/replies. this helped me to decide right datatype & formating. thanks again

thanks for your reply. i would like to know what is this number "2147483647" & from where this is coming from, also if you have memory more than 4GB still...

most or all of your columns are nvarchar so Clustered Index is not recommended. NON-CLUSTERED index is only good on those columns which as uniqueue value of more than 95%. for e.g....

"Select * from master.dbo.sysperfinfo where counter_name = 'User connections'"

this only works for Window NT 4.0 & doesn't give any connection info.