Well thanks Andras, that some good solution and its working fine now. I have few more doubts....

1. In sp_addlinkedserver the parameter @srvproduct='sql server' then none of the other parameter is...

Thanks for the reply Matt,

I just want to return 1 if the last statement( which will be one of the statements in else-if block) is executed successfully but it returns...