I created the linked server as follows: SQLSERVER 2000->EM->Security->Linked Server->New Linked Server->General ->Name of the linked server i gave the name of sql express 2005.And select SERVER TYPE as SQL...

Thank you very much for your reply.I tried to create a linked server,but it's not linking properly and i can't view the tables in linkes server.Can you please tell me...

Hi,

Thank you very much for your reply.I used that code ,it works fine.I amso happy.

Regards,

Pallavi.