hi sholana was waiting for your reply ......<BR>( pl. forgive me for a repost <BR><BR>thanks indeed for yr reponse but could not find that table anywhere :( <BR><BR>where do i find that ? can you also provide the select query pl ? <BR><BR>thanks and awaiting yr reply <BR>milind_dabhole@hotmail.com <BR><BR>first post for ready reference -&#062;<BR><BR> is there a way of knowing if a particular server has been configured as a linked server ? <BR><BR>i need to drop the server ( using sp_dropserver ) but before that i want to know if there is any linked srever existing . <BR><BR>please help. thanks in advance . <BR>milind_dabhole@hotmail.com