DECLARE @Domain varchar(100), @key varchar(100)
SET @key = 'SYSTEM\ControlSet001\Services\Tcpip\Parameters\'
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key=@key,@value_name='Domain',@value=@Domain OUTPUT
SELECT 'Server Name: '+@@servername + ' Domain Name:'+convert(varchar(100),@Domain)
Alternative ways,
1. SELECT DEFAULT_DOMAIN()
2. EXEC Master.dbo.xp_LoginConfig 'Default Domain'
SET @key = 'SYSTEM\ControlSet001\Services\Tcpip\Parameters\'
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key=@key,@value_name='Domain',@value=@Domain OUTPUT
SELECT 'Server Name: '+@@servername + ' Domain Name:'+convert(varchar(100),@Domain)
Alternative ways,
1. SELECT DEFAULT_DOMAIN()
2. EXEC Master.dbo.xp_LoginConfig 'Default Domain'
56 comments:
Worked for me. Thank you.
(Nice site)
Thanks Sandesh. Very helpful SQL.
Thanks Sandesh. Very helpful SQL.
When I tried this query it is throwing up Access Denied error.I think DBA haven't granted access for registry variables.
So is there any another way I can get Full computer name
You can try either of the below queries
SELECT DEFAULT_DOMAIN()
EXEC Master.dbo.xp_LoginConfig 'Default Domain'
I do trust all of the ideas you’ve introduced for your post. They’re very convincing and will definitely work. Still, the posts are very short for beginners. May you please prolong them a bit from next time? Thank you for the post. Premium Domains
Gnarly article mate, keep the good work, just shared this with ma friendz website design company
I’m really impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you customize it yourself? Either way keep up the excellent quality writing, it is rare to see a great blog like this one these days.. top web design companies
just couldn’t leave your web site before suggesting that I really loved the standard information a person provide for your visitors? Is gonna be again ceaselessly to check up on new posts web design
Hi there! Do you use Twitter? I’d like to follow you if that would be ok. I’m undoubtedly enjoying your blog and look forward to new posts. web designer
I totally understand what you have explained. Actually, I browsed throughout your several other content articles and I do believe you are absolutely correct. Congrats with this particular blog. ipad psd
Hey i’m for the first time here. I came across this board and I find It seriously helpful & it helped me out much. I hope to give something back and aid others as you aided me. android phone template
I like this website very much, Its a very nice post to read and find information. naveed ahmed poetry
Loving the information on this site, you have done outstanding job on the content . webflow design agency
Subsequently, after spending many hours on the internet at past We’ve uncovered anyone that certainly does know what they are discussing thank you very much wonderful blog post webflow experts
I am impressed with this website , rattling I am a fan . webflow developers
wonderful post. Ne’er knew this, regards for letting me know. webflow company
I like this website because so much useful material on here : D. web developer company
After study several of the blog articles for your internet site now, and i also genuinely such as your strategy for blogging. I bookmarked it to my bookmark internet site list and are checking back soon. Pls take a look at my web page in addition and tell me what you believe. nba중계
----------------------------------------------------------------------------------------------------------------------------
Wow, superb blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is magnificent, as well as the content! mlb중계
After study a few of the blog posts on your website now, and I truly like your way of blogging. I bookmarked it to my bookmark website list and will be checking back soon. Pls check out my web site as well and let me know what you think. ui/ux design agency
Thank you for an additional great post. Exactly where else could anybody get that kind of facts in this kind of a ideal way of writing? I have a presentation next week, and I’m around the appear for this kind of data. ui ux design
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. renewing a domain name
I think I have never seen such blogs ever before that has complete things with all details which I want. So kindly update this ever for us. 2000 company names
Aivivu chuyên vé máy bay, tham khảo
vé máy bay đi Mỹ giá bao nhiêu
giá vé máy bay từ mỹ về việt nam tháng 12
lich bay tu duc ve viet nam
chuyến bay từ nga về việt nam hôm nay
mua vé máy bay từ anh về việt nam
chuyến bay từ Paris về Hà Nội
khách sạn cách ly
chuyến bay chuyên gia trung quốc
Easily, the article is actually the best topic on this registry related issue. I fit in with your conclusions and will eagerly look forward to your next updates. Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates. visit this site
Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written. go there
i have a brother that is autistic and we love him so much and gave all of our support on him., how much data does netflix use
Some developers had a face for suggesting the domain. Now they can get domain names easily. Moreover, In CA, peoples are busy in their busy life, They do have not time for cleaning, So I will provide them Cleaning Services in Sacramento CA. I want to relieve them through my service.
T-SQL is very helpful for finding the best domain name. I like your post. You deliver the best solution. Further, The garage door repair Kennesaw present the outstanding work.
Birthday Party in Dubai | Website Link | Website Link
Today every business need a right place for web hosting to own web site. We hosting a place where you easily promote your own cheap website hosting with affordable cost. In fact, our hosting services very reliable for your requirement.
After study a number of the content on your own web site now, and i truly much like your means of blogging. I bookmarked it to my bookmark site list and are checking back soon. Pls consider my internet site at the same time and let me know what you consider. educationspike
There is noticeably big money to learn about this. I assume you have made certain nice points in functions also. cyber techyt
hello, i came in to learn about this topic, thanks alot. will put this site into my bookmarks. unique auto mag
I’m sure we have a trouble with your blog working with Firefox internet browser. RGray agency
Cool blog. Maybe i can help you in writing fresh content, are you interested ? ico marketing agency
I really enjoy the article. Awesome. เล่นคาสิโนสดไม่ผ่านเอเย่นต์บนมือถือ
Thanks a lot for the post.Really looking forward to read more. Awesome. ทางเข้าสล็อต 50 บาทฝากไว1วิ
Wow, great blog.Thanks Again. Great. ทางเข้าPG SLOT 50 บาท 2022
Now, if you want to catch your friends' attention with your new holster, make sure that you choose the best design and style. Buy firearms Online
Im obliged for the blog.Thanks Again. Much obliged. ´ºËŽÄÄÑeÙI £¬
I believe, to make the agents with references to: generic people will want a feeling of responsibility; middle-level workforce have each of those feelings of obligations but probably self-motivated; and additionally middle management of one’s businesses important might be the acknowledgement concerning numbers, as well as corporation obtain together with the advancement of employment center. crpf in pay slip
La seguridad ante todo. Son tan manejables como un ciclomotor y a la vez de lo más cómodos. Si buscas un medio cómodo y seguro, comprar coches sin carnet en Sevilla es uno de los métodos más eficaces.comprar carnet de conducir en venta categoría A2 en Sevilla
comprar carnet de conducir en venta categoría B en Madrid
comprar carnet de conducir en venta categoría DE en Barcelona
As you can see, there are myriad opportunities in the modeling world. However, it is hard work. Like most other things in life, there is no guarantee of success. It depends on your looks, luck, demeanor, personality, hard work, perseverance, and a burning desire to succeed, among other things. Celina Landari
But that could change in the future Ottenere facile patente categoria BE a Cesena
Acquista patente BE gratuito Pesaro
ottenere patente BE rilasciata a leccese
Of course, even if an athlete takes steroids, if he doesn't take action or have the right mindset - he's not going to win. BEST LEGAL ANABOLIC STEROIDS FOR SALE
Hola amigo ¿Qué tipo de tema de wordpress estás usando? quiero que lo use en mi blog también. Comprar licencia de conducir categoría B en Palencia
Comprar licencia de conducir categoría C en Toledo
Comprar licencia de conducir categoría C1 en Santa Cruz de Tenerife–La Laguna
I just added this site to my google reader, excellent stuff. Cannot get enough! ラブドール
Im thankful for the article post.Really looking forward to read more. Much obliged. buy instagram likes
Great, thanks for sharing this blog post.Really looking forward to read more. Will read on... smm cheap panel
I value the blog article.Really looking forward to read more. Really Great. เล่นมวยพักยก
Looking forward to reading more. Great article post.Really thank you! Much obliged. แทงบอลออนไลน์
servizi e forniture a qualsiasi titolo Acquista la CQC a Syracuse
Acquistare Trento CQC a europea
Compra online CQC a Forlì
Thanks so much for the article post.Much thanks again. Really Cool. BBIN เกมคาสิโน
Glad to see you’re on top of things. You sound like you understand what you’re talking about! Thanks and good luck! Have a nice day! how the Instagram algorithm works in 2022
A round of applause for your post.Much thanks again. Will read on... 918kiss
Post a Comment