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
42 comments:
Thnx a lot.. god bless...
SELECT CLIENT_NET_ADDRESS AS [IP Address Of Client]
FROM SYS.DM_EXEC_CONNECTIONS
WHERE SESSION_ID = @@SPID
RESULT >>> local machine
Help Me plese
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.
Computer devices in the network configuration like PCs, printers, scanners and other machines are assigned with IP addresses. UK IP Restriction
i am unable to run this query in my sql, What are the permissions to perform this action.
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
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
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
Very Informative Article
Data Science Interview Questions
I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
data analytics course
This is exactly the information I'm looking for, I couldn't have asked for a simpler read with great tips like this... Thanks! ExcelR Data Analytics Courses In Pune
Know more about Data Analytics
Cool stuff you have, and you keep overhaul every one of us.
wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
data analytics course in Bangalore
wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
data analytics course in Bangalore
wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
Data Science Course
Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Correlation vs Covariance
Simple linear regression
Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Correlation vs Covariance
Simple linear regression
data science interview questions
After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
Simple Linear Regression
Correlation vs Covariance
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
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
Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Simple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
Great Article Artificial Intelligence Projects
Project Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
I like to post tiktok video about code and buy tiktok likes from this site https://soclikes.com/buy-tiktok-likes
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
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
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
I enjoy it for creating the details, keep up the truly amazing perform continuing ExcelR Data Analytics Courses
Nice post and this is very helpful to develop my skills. Thank you...
WordPress Training in Chennai
WordPress Course in Chennai
HTML5 Training in Chennai
Thanks for the informative and helpful post, obviously in your blog everything is good.. ExcelR Data Analyst Course
Welcome! Exceptionally supportive counsel inside this article! It is the little changes that produce the biggest changes. Much obliged for sharing!
liveskye
Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
Data Science Course in Bangalore
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
Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
Data Science Training in Bangalore
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
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
data analytics course in bangalore
I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
artificial intelligence course in pune
I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
data analytics training in bangalore
Thanks for posting the best information and the blog is very informative.data science interview questions and answers
Post a Comment