linked server

Can anybody tell me how do we create linked server between one SQL server to another SQL server
TIA
JohnSure, use either Enterprise Mangler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_servpem_1ozd.asp) or Query Analyzer (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp).

-PatP|||best thing is to use the enterprise manager and go to security and right click linked servers and add a new linked server.
another method would be to run the sp_Addlinkedserver stored procedure
both of these methods could be looked up in BOOKS ONLINE which is a free help file included with sql server.