>All,
>
>How can I get the MSSQL server name? I have the ODBC name,user name,database name and password.
>
>When I use 'EXEC SP_LINK" get it sometime I can get wrong server name?
>
>Regards

Ricky,

Have you looked a SQL-DMO in the BOL?

I don't know if that'll help, but I think that there might be a way to get the server name.