>Is there a way to programmaticly determine the network address of the box hosting the sql server my app is connected to? ( assuming the connection string is obfuscated within the app ) ?
Google [sql server ip address]. Looking at a few of the hits, they seem to rely on running the IPConfig command-line utility via the xp_cmdshell extended stored procedure (which you may not have permission to run).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up