Re: Scripting creation of server alias
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/06/04
- Next message: Jonas Larsen: "Lost Stored Procedures"
- Previous message: Richard: "Need Dirxn --> How to schedule recurring stored procedure executio"
- In reply to: allancady_at_yahoo.com: "Scripting creation of server alias"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 18:21:01 -0500
allancady@yahoo.com wrote:
> Does anyone know if there's a way to script creation of a server
> alias, as you can do using the Client Network Utility?
Do you mean from a T-SQL script? The utility just writes to the
registration database. Sniff the regdb while you perform adding a new
alias and see where it goes. Then you can use any programming tool or
just a .reg file to add the new data to everyones PC. From a domain this
is easy.
You can sniff the regdb using free tools from www.sysinternals.com
-- David Gugick Imceda Software www.imceda.com
- Next message: Jonas Larsen: "Lost Stored Procedures"
- Previous message: Richard: "Need Dirxn --> How to schedule recurring stored procedure executio"
- In reply to: allancady_at_yahoo.com: "Scripting creation of server alias"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
