Monday, January 24, 2011

how to get host/port,host name,server name,and db name in syabse 

select address_info as "host/port"
      ,host_name() as "hostname"
      ,@@servername as "servername"
      ,db_name() "current_dbname"
from master..syslisteners
select address_info as "host/port"
      ,host_name() as "hostname"
      ,@@servername as "servername"
      ,db_name() "current_dbname"
from master..syslisteners
 StumpleUpon Ma.gnolia DiggIt! Del.icio.us Blinklist Yahoo Furl Technorati Simpy Spurl Reddit Google
Posted by Sri at Monday, January 24, 2011
Labels: , , ,

2 comments:

Anonymous said... November 18, 2011 at 12:32 AM

you query looks good but remember that we have to run check this on different version, please see below options

select @@servername
select net_type, substring(address_info,1,35) 'address_info' from master..syslisteners --Version 12.5
go

select @@servername
select net_type, substring(address_info,1,35) 'address_info', spare, nodeid from master..syslisteners --Version 15
go

Anonymous said... September 27, 2014 at 10:46 PM

This code, is incorrect

Post a Comment

Subscribe to: Post Comments (Atom)