T-SQL Query to find IP Address of SQL Server | SansSQL

Saturday, March 23, 2013

T-SQL Query to find IP Address of SQL Server

Here is a handy T-SQL script to find the IP Address of the SQL Server you are connected to.

SELECT CONNECTIONPROPERTY('local_net_address') AS [IP Address Of SQL Server]

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') [Machine Name]
   ,SERVERPROPERTY('InstanceName') AS [Instance Name]
   ,LOCAL_NET_ADDRESS AS [IP Address Of SQL Server]
   ,CLIENT_NET_ADDRESS AS [IP Address Of Client]
 FROM SYS.DM_EXEC_CONNECTIONS 
 WHERE SESSION_ID = @@SPID

61 comments:

Kay bee said...

Thnx a lot.. god bless...

thongchai.jindatam said...

SELECT CLIENT_NET_ADDRESS AS [IP Address Of Client]
FROM SYS.DM_EXEC_CONNECTIONS
WHERE SESSION_ID = @@SPID


RESULT >>> local machine

Help Me plese

Sandesh Segu said...

You have to run this query from a remote PC to get IP address. If you are running from the same server as SQL server then the query returns Local Machine.

Unknown said...

Computer devices in the network configuration like PCs, printers, scanners and other machines are assigned with IP addresses. UK IP Restriction

SATEESH said...

i am unable to run this query in my sql, What are the permissions to perform this action.

Muhammad Hassan said...

Excellent website! I adore how it is easy on my eyes it is. I am questioning how I might be notified whenever a new post has been made. Looking for more new updates. Have a great day! 192.168

Anonymous said...

Much obliged to you again for all the learning you distribute,Good post. I was exceptionally intrigued by the article, it's entirely rousing I ought to concede. I like going by you site since I generally run over fascinating articles like this one.Great Job, I enormously acknowledge that.Do Keep sharing! Respects, check my ip address

markson said...

In the time of 2012 Gartner had anticipated that employment opportunities in Business Analytics and Data Scientist are surrendering to head toward somewhere in the range of Millions preceding 2015 attract to a nearbyData Analytics Course

priyanka said...

I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
data analytics course

360digitmgas said...

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. best software training

Robert Beauty said...

I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day!192.168.1.254

Mike Johnson said...

I like to post tiktok video about code and buy tiktok likes from this site https://soclikes.com/buy-tiktok-likes

Huongkv said...

Aivivu vé máy bay giá rẻ

vé máy bay tết

Vé máy bay đi Mỹ

vé máy bay Việt Nam đi Pháp

vé máy bay 1 chiều đi hàn quốc

giá vé máy bay đi osaka nhật bản

giá vé máy bay từ Hà Nội đi Anh

arshiya said...

Awesome article, I really enjoyed reading your blog. This is truly a great read for me.
what is keyword stuffing in seo
machine learning scope
angularjs plugins
rpa software
angularjs interview questions and answers
angularjs interview questions for freshers

Farhan.Jee said...

The python programming language is a modern web programming language that was originally conceived and developed by Guido van Rossum in the 1980s. Since that time, Python has evolved into a high-performance programming language that is modular and extensible. data science course in india

borav said...

Welcome! Exceptionally supportive counsel inside this article! It is the little changes that produce the biggest changes. Much obliged for sharing!
liveskye

aivivubooking1 said...

Mua vé máy bay tại Aivivu, tham khảo

vé máy bay đi Mỹ giá bao nhiêu

lịch bay từ california về việt nam

giá vé máy bay từ anh về việt nam

chuyến bay từ paris về hà nội

AI said...

ExcelR provides Data Analytics courses. It is a great platform for those who want to learn and become a Data Analytics course. Students are tutored by professionals who have a degree in a particular topic. It is a great opportunity to learn and grow.


Data Analytics courses

Viktoriya said...

The cloud is here to stay. We're at a point where organizations are moving from dabbling in cloud provisioning to making it the backbone of the IT infrastructure. According to "The New IT Normal: Cloudy and Getting Cloudier," by Arthur Cole: salesforce training in noida

Alia parker said...

It's always nice and I feel honored reading your Blog. Your Blogs always based on all basic concepts like Primavera P6 Fundamentals which anyone can understand so easily and relate to Pleasure to read your Blogs buddy.

360DigiTMG-Pune said...

Good information you shared. keep posting.
data science training in pune

360DigiTMGAurangabad said...

Hi Thanks for Sharing this Valuable Information with us: this is very useful for me. Keep it Up.
artificial intelligence course in aurangabad

DOĞAN CAN said...

instagram takipçi satın al - instagram takipçi satın al - takipçi satın al - takipçi satın al - instagram takipçi satın al - takipçi satın al - instagram takipçi satın al - aşk kitapları - tiktok takipçi satın al - instagram beğeni satın al - youtube abone satın al - twitter takipçi satın al - tiktok beğeni satın al - tiktok izlenme satın al - twitter takipçi satın al - tiktok takipçi satın al - youtube abone satın al - tiktok beğeni satın al - instagram beğeni satın al - trend topic satın al - trend topic satın al - youtube abone satın al - beğeni satın al - tiktok izlenme satın al - sms onay - youtube izlenme satın al - tiktok beğeni satın al - sms onay - sms onay - perde modelleri - instagram takipçi satın al - takipçi satın al - tiktok jeton hilesi - pubg uc satın al - sultanbet - marsbahis - betboo - betboo - betboo

SEO Services said...

Very interesting to read this article. i would recommended. pdf to ppt

Unknown said...

Works only from a remote computer. Running it locally will result in a localhost address. This issue among the problem of social media growth services was widely discussed on Instagram about a year ago. I remember this topic scored a dozen thousands of likes, you can find more about this by this link.

SEO Services said...

I am not sure where you are getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for wonderful information. Anti captcha key

Huongkvb said...

Mua vé máy bay tại Aivivu, tham khảo

Ve may bay di My

ve may bay từ mỹ về việt nam hãng eva

khi nào có chuyến bay từ canada về việt nam

vé máy bay nhật việt vietjet

vé máy bay từ hàn quốc sang việt nam

Vé máy bay từ Đài Loan về VN

danh sách khách sạn cách ly

Chi phi cho chuyen gia nuoc ngoai

Kale white said...

Hello
Please i just took up macaw breeding as a hobby after my mom passed away because they were her favorite birds. Despite the fact that they are very intelligent, am finding it very difficult getting them to mate.
For any information CLICK HERE http://supremeparrotfarm.company.com/ we shall get back to you. contact-about-us. THANKS

Unknown said...

Ucuz, kaliteli ve organik sosyal medya hizmetleri satın almak için Ravje Medyayı tercih edebilir ve sosyal medya hesaplarını hızla büyütebilirsin. Ravje Medya ile sosyal medya hesaplarını organik ve gerçek kişiler ile geliştirebilir, kişisel ya da ticari hesapların için Ravje Medyayı tercih edebilirsin. Ravje Medya internet sitesine giriş yapmak için hemen tıkla: https://www.ravje.com

İnstagram takipçi satın almak için Ravje Medya hizmetlerini tercih edebilir, güvenilir ve gerçek takipçilere Ravje Medya ile ulaşabilirsin. İnstagram takipçi satın almak artık Ravje Medya ile oldukça güvenilir. Hemen instagram takipçi satın almak için Ravje Medyanın ilgili sayfasını ziyaret et: instagram takipçi satın al

Tiktok takipçi satın al istiyorsan tercihini Ravje Medya yap! Ravje Medya uzman kadrosu ve profesyonel ekibi ile sizlere Tiktok takipçi satın alma hizmetide sunmaktadır. Tiktok takipçi satın almak için hemen tıkla: tiktok takipçi satın al

Unknown said...

Your comment will be visible after approval

Jobi Johnson said...

I was very impressed by this post, this site has always been pleasant news Thank you very much for such an interesting post, and I meet them more often then I visited this site. sherlock coat

Hyder Ak47 said...

I want to leave a little comment to support and wish you the best of luck.
Mobile Prices Bangladesh

Kims leonard said...

Usually I never comment on article but your article is so convincing that I never stop myself to Real Leather. best chihuahua puppies for sale chihuahua puppy for sale, tea cup chihuahua puppies for sale, chihuahua puppies for sale near me, sphynx cat sale

Credo Systemz said...

AWS Training in Chennai

APKsunny.com Mod Apk said...

How to Download and Install Mega Shows Apk

You can use Mega Shows apk to stream various TV shows and movies from different countries. You can watch your favorite TV series and movies for free. The best thing about this app is that it is available for both Android and iOS devices. You can also download the latest episodes of popular television series. Here's how to download the Mega Shows apk: To install Megashows apk, first go to your device's settings and then select the Mega Shows app.

Mega Shows has an apk file that you can download. If you have an Android smart TV, simply transfer the APK file to your device's storage. If you're using a PC, open the file in Bluestacks and install it. You should see the installation process take a while but once it's done, you're good to go! To watch Mega Shows, you can follow the steps below.

One of the biggest advantages of Mega Shows is that it's free to download. Once you've installed the app, you can choose from hundreds of movies and TV shows. If you're a fan of television shows, you'll definitely enjoy Mega's huge library. You can also watch TV serials, movies, and documentaries. In fact, you can even watch full-length television series. The best part is that you can even request your favorite movie or TV show.

Besides downloading the Mega Shows apk, you can also request shows and movies. You can earn rewards for completing tasks. For example, you can win 100$ by making a 3-minute video and submitting it to the app. This is a great way to watch movies and TV series for free. The app also has a user-friendly interface, as well as a search engine. All this is available at no cost!

Mega Shows is a fantastic app that lets you watch and download all kinds of TV shows. This application is completely free, so you don't need to sign up or pay anything. You can also access the same content on your PC or tablet, and you can use it on any device. But be aware that it's not available in the Play Store yet. It's important to download the Mega Shows apk first before installing it on your TV.

There are several ways to download Mega Shows apk for Android. You can use it on your iOS or Android device. It works on all of your devices. If you want to watch TV shows on your PC, you can install the Mega Shows apk on your Firestick. And if you don't want to use your phone to watch TV, you can also use Megashows apk on your smart TV.

Near Learn said...
This comment has been removed by the author.
Unknown said...

Thank you for this informative article. I learned so much from it. Our free email signature maker will help you build a brand identity with a personalized email signature. Create your own email signature online with our free tool. Easily create a signature for your email using our email signature generator

Unknown said...

C-GUARD has a wide range of scrub suits like the basic scrubs that can be used by all Doctors, medical & para medical staff, medical students, interns etc.Cguard

Ramesh Sampangi said...

Nice information, informative and knowledgeable content. Keep sharing more blogs with us.
Data Science Course in Hyderabad

Real Jackets said...

Thanks for your marvelous posting! I certainly enjoyed reading
it, you might be a great author. I will ensure that I bookmark your blog
and will come back from now on. I want to encourage you continue
your great writing, have a nice holiday weekend!lakers jacket with championship

hello bro said...

Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, Pet Care adda
how to activate flipkart axis bank credit card, the millionaire next door
,The Price Of Flowers Summary

traininginstitute said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
full stack web development course

shailendra said...

Best Private Universities in India for student placement

Best University of Yoga and Naturopathy in Uttarakhand


Sophia said...

Wow, that's what I was looking for, what stuff! Present here on this website, thanks to the admin of this website.. Turkish businessperson visa , You can apply Turkish visa online through the e Visa Turkey website.It takes 3-5 minutes to fill in the online application.

PMP Training in Malaysia said...

I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles.

traininginstitute said...

I quite like reading an article that can make people think. Also, thanks for allowing for me to comment!
cyber security course

data science said...

You really make it look so natural with your exhibition however I see this issue as really something which I figure I could never understand. It appears to be excessively entangled and incredibly expansive for me.

isabella said...

I just want to let you know that I am a beginner to blog and of course I have enjoyed your web page. What is an Indian Business Visa? Indian Business Visa is an electronic business travel authorization. Apply for Indian business e-visa online through the Indian Visa website, and the cost for the Indian business e-Visa depending on the traveler's nationality and the urgency of the visa required by the traveller.

George Mark said...

Fantastic blog i have never ever read this type of amazing information. Aot Cape

Unknown said...

To know about automated AI service desk and help desk. click here
ai help desk

Go Lagu said...

You should experience a tournament personally of the greatest blogs on the web. I most certainly will suggest this site! web designers near me

Ranjan said...

Nice article please
Movie Zone News

Andre Van den berg said...


Hi, I think this is very useful information. The article is inspiring me to have the same mindset as you. Are you interested in visiting India? Travel to India requires an Indian visa. I don't no about what is medical visa in India? I found this site & read the Indian e visa page and I got knowledge about medical visa India & requirements. Then apply through this site. It's really great service! I received my visa online within days. Amazing service and super helpful. I recommend it to everyone!

sync said...

2. defa geldim ve çok güzel yorumladım.

Guy's Dating Room said...

Here all features are totally unlocked and unlimited. asphalt 9 unlimited tokens generator

Isabella Ava said...

Thank you for giving me a chance to read this wonderful article. Thanks a lot! Indian e visa online for foreign nationals. India e visa online is an online travel authorization to travel to the country for tourism / business/medical/conference purposes. Foreign nationals can be apply e visa Indian online. You can find out all the information about Indian Visas through our website.

jackman10 said...

There are a handful of intriguing points with time in this article but I do not determine if them all center to heart. There is certainly some validity but I’m going to take hold opinion until I explore it further. Good post , thanks therefore we want much more! Combined with FeedBurner at the same time whatsapp hacking services

Digital Keshav said...

Great Article!
summer internships 2022
outsource website design

Caiz Coin said...

Rattling excellent info can be found on web blog . webflow development

Vietnameximp said...

Get customs import export data at vietnameximp. We are the leading import export data providers for vietnam. Visit our website for more information.
Vietnam Export Data

iteducationcentre said...

Thanks for posting such an useful and informative blog.
SQL classes in Pune

Post a Comment

Ads