Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / sql - query to get server's ip address
Ask Question

SQL - Query to get server's IP address

Anonymous User 2500 16 Apr 2013
Hi All!

Is there a query in SQL Server 2005 I can use to get the server's IP or name?

Thanks in advance!
mssql server mssql server
Updated 16 Apr 2013
Anonymous User
Anonymous User

Other

I am a content writter !

Message

1 Answers

AVADHESH PATEL
AVADHESH PATEL 16 Apr 2013
Report Abuse
Hi Jeet!

You can get server name as below

SELECT @@SERVERNAME;

IP Addresss or Name as below

SELECT SERVERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SERVERNAME'))  
,LOCAL_NET_ADDRESS AS 'IPAddressOfSQLServer' 
,CLIENT_NET_ADDRESS AS 'ClientIPAddress' 
--, NETBIOS = CONVERT(NVARCHAR(128),SERVERPROPERTY('COMPUTERNAMEPHYSICALNETBIOS'))  
--, [MAXDOP] = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX DEGREE OF PARALLELISM')   
--, SQLMEMORY = (SELECT VALUE_IN_USE FROM SYS.CONFIGURATIONS WHERE NAME='MAX SERVER MEMORY (MB)')  
--, EDITION = CONVERT(NVARCHAR(128),SERVERPROPERTY('EDITION'))  
---, COLLATION = CONVERT(NVARCHAR(128),SERVERPROPERTY('COLLATION'))  
--, ISCLUSTERED = CONVERT(BIT,SERVERPROPERTY('ISCLUSTERED'))  
--, ISFULLTEXTINSTALLED = CONVERT(BIT,SERVERPROPERTY('ISFULLTEXTINSTALLED'))  
--, ISINTEGRATEDSECURITYONLY = CONVERT(BIT,SERVERPROPERTY('ISINTEGRATEDSECURITYONLY'))  
--, FILESTREAMCONFIGUREDLEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMCONFIGUREDLEVEL'))  
--, FILESTREAMEFFECTIVELEVEL = CONVERT(TINYINT,SERVERPROPERTY('FILESTREAMEFFECTIVELEVEL'))  
--, PRODUCTVERSION = CONVERT(NVARCHAR(128),SERVERPROPERTY('PRODUCTVERSION'))  
--, SQLCHARSETNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLCHARSETNAME'))  
--, SQLSORTORDERNAME = CONVERT(NVARCHAR(128),SERVERPROPERTY('SQLSORTORDERNAME')) 
 FROM SYS.DM_EXEC_CONNECTIONS WHERE SESSION_ID = @@SPID

MindStick Training