servers

how to get the list of linked servers
i have to apply filter in that

i am using the sp_linkedservers but this is returning whole list of servers . but i need whether specified server name exists.

is it possible to store the outcome of the sp in a temp table and after querying the things from the temptable

very urgent pls help!!!

Thanks in advance

raj

select * from sys.servers where name = 'myserver' --for sql server 2005

select * from sysservers where name = 'myserver' -- for sqlserver 2000

|||ThnX, nitin