If you ever need to know what is database name based on a data or transaction log file location, run the following T-SQL code.
select d.name, m.name, m.physical_name
from sys.master_files m
inner join sys.databases d
on (m.database_id = d.database_id)
where physical_name = N'D:\Data\datafile.mdf' --change the full path file
order by 1, 2
54 Responses
join with sys.databases is not needed here
use db_name(database_id) function to get database name
I really like it whenever people come together and share ideas. Great website, keep it up. Danita Cozmo Aruabea
1Learn more about how to get free gems on cooking fever
u3iauds11
This game is a whole lot more fun when you have as many gems as you could ever want.If you like mobile games like this you ought to check out this link
Im obliged for the blog article. Really looking forward to read more. Mac Solie
My family every time say that I am killingmy time here at web, except I know I am getting know-how daily byreading thes fastidious content. Howard Dahlstedt
Great looking web site. Think you did a bunch of your very own coding. Bert Kapichok
Having read this I believed it was really informative. Fredric Oppliger
Where there is a will, there is a way.
I was able to find good information from your content. Edwardo Florendo
You have a bloody exciting website. I like the whole word that you provender with every article. Kraig Soffer
Thank you for visiting my blog and taking time to comment. Mckinley Khanponaphan
We came across a cool web-site that you might enjoy. Take a search in the event you want. Lionel Sliter
Some genuinely excellent articles on this internet site , regards for contribution. Jermaine Linzie
Excellent post. I am dealing with some of these issues as well.. Dion Capossela
Greetings! Very helpful advice in this particular article! It is the little changes that make the most important changes. Thanks for sharing!
100,000 Backlinks only $10,Subject to data from ahrefs.com.After paid $10 by PayPal (My PayPal:helloboy1979@gmail.com),Tell me your URL, email and comment content.I will complete the task within ten days.But It may take up to a month for the data updated from ahrefs.com.
Major thankies for the article. Much thanks again. Great. Ramon Cuttitta
I have noticed that of all different types of insurance, medical health insurance is the most controversial because of the discord between the insurance cover company’s necessity to remain making money and the buyer’s need to have insurance coverage. Insurance companies’ commissions on health plans are certainly low, as a result some companies struggle to earn profits. Thanks for the thoughts you talk about through this blog.
I got what you intend,bookmarked, very decent website.
A lot of blog writers nowadays yet just a few have blog posts worth spending time on reviewing.
My website: любительское порно на русском
I reckon something truly special in this website.
My website: порно толпой
A lot of blog writers nowadays yet just a few have blog posts worth spending time on reviewing.
My website: домашний оргазм
Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol
My website: домашнее порно оргазм
Major thanks for the article post. Much thanks again.
My website: пьяные русские порно
Respect to post author, some fantastic information
My website: любительское порно
As a Newbie, I am always searching online for articles that can help me. Thank you
My website: домашнее порно любительское
Major thanks for the article post. Much thanks again.
My website: довел до оргазма порно домашнее
Major thanks for the article post. Much thanks again.
My website: домашний секс студентов
Respect to post author, some fantastic information
My website: зрелые порно анал
Definitely, what a great blog and revealing posts, I definitely will bookmark your site. Best Regards!
My website: анал хд
I am incessantly thought about this, thanks for posting.
Muchos Gracias for your article.Really thank you! Cool.
A round of applause for your article. Much thanks again.
My website: порно русское домашнее видео
That means you’ll get the idea some new features and press access to additional channels where you can gain visibility, without having to designate import of some confused, handbook migration process. https://googlec5.com
My website: в жопу бесплатно
I reckon something truly special in this website.
My website: cartoon porn