Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cwalston
Starting Member
25 Posts |
 Posted - 2007-08-17 : 15:23:38
|
| Hi, Is there a way query for the server's ip address and port the sql server is running on? I am thinking it's gotta be somewhere in the system tables...Thanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:48:53
|
| No, in registry. You can get it in sql server log also. |
 |
|
|
cwalston
Starting Member
25 Posts |
Posted - 2007-08-20 : 11:20:35
|
| Would you have any examples of querying the registry in SQL Server?Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:13:48
|
| Can use master..xp_regread. |
|
|
|
|
|
|
Ip address and port