/*
   Linked servers queries

   Prabu 6/6/05
*/  

-- List all linked servers
sp_linkedservers

sp_dropserver 'teachsql.aul.fiu.edu'

sp_linkedservers

sp_addlinkedserver 'teachsql.aul.fiu.edu'

sp_linkedservers

sp_addlinkedsrvlogin 'teachsql.aul.fiu.edu', 'cgs4366', 'microsoft'


select ssn
from [teachsql.aul.fiu.edu].cgs4366.dbo.employee;


select salary
from openquery([teachsql.aul.fiu.edu],
  'select * from cgs4366.dbo.employee');


