Removing a server

I am trying to remove a server name from SQL Server 7.0
server by using the,
sp_dropserver 'SERVER2'
but keep getting the error of
'There are still remote logins for the server 'SERVER2'
SERVER2 no longer exists. How can I remove this server
from the Current SQL Server and/or how can I find
the 'remote logins' that belong to this server ?
Thanks.
Try sp_droplinkedsrvlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>I am trying to remove a server name from SQL Server 7.0
> server by using the,
> sp_dropserver 'SERVER2'
> but keep getting the error of
> 'There are still remote logins for the server 'SERVER2'
> SERVER2 no longer exists. How can I remove this server
> from the Current SQL Server and/or how can I find
> the 'remote logins' that belong to this server ?
> Thanks.
|||That did it......Thanks.......

>--Original Message--
>Try sp_droplinkedsrvlogin.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018a01c52f24$aba96260$a401280a@.phx.gbl...
>
>.
>