How to add a Network Library Config (Server Alias) using Transact-

Hi,
I can create an Alias for a remote server fine using the Client Network
Utility (Alias tab, Add -> "Add Netwok Library Configuration" - TCP/IP,
Server name = IP Address, specify port number).
... how can I accomplish the same thing using TRANSACT-SQL so I can create
a
script which will do this for my customer.
Thanks in advance, J
Jamie Clancy
Ulysses Systems, LondonI don't think this is in TSQL's scope of functionality--it's a networking /
DNS configuration, not a SQL Server config. It seems to me you might try
changing the Hosts file on the client system--it can do about the same
thing...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Jamie_C" <jclancy@.ulysses-systems.com.removethisbit> wrote in message
news:AD9F9920-B4CF-45D0-84CF-ECE22B0142B5@.microsoft.com...
> Hi,
> I can create an Alias for a remote server fine using the Client Network
> Utility (Alias tab, Add -> "Add Netwok Library Configuration" - TCP/IP,
> Server name = IP Address, specify port number).
> ... how can I accomplish the same thing using TRANSACT-SQL so I can create
> a
> script which will do this for my customer.
> Thanks in advance, J
> --
> Jamie Clancy
> Ulysses Systems, London