How to Find Out Owner of Any Database in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to find out owner of any database in SQL Server instance? you will learn following ways to accomplish this task.
1- How to find owner of any database in SQL Server using Store Procedure
2- How to find owner of any database in SQL Server using System views

Scripts:

--Finding owner of database using Store Procedure
sp_helpdb

--Finding out Owner of databse using sysdatabses system view 
select name as DatabaseName,SUSER_SName(sid) as Database_Owner from sysdatabases

--Where name = 'Your desired database name'

--Finding owner of database using sys.databases system view
Select name as DatabaseName, SUSER_SNAME(Owner_sid) as Database_Owner from sys.databases
--Where name = 'Your desired database name'



How to Find Out Owner of Any Database in SQL Server - SQL Server DBA Tutorial

3 comments:

  1. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete
  2. Yes it is possible to recover your stolen bitcoins. I never believed in bitcoin recovery because I was made to understand that it was not possible. However, sometime in February I fell for a forex scam which promised overly high returns and I ended up losing close to $500,000. I searched for a month for help until I finally came across an article on reddit in regards to recovering stolen cryptocurrency so I reached out to them, Recover Btc Help Wizard Charles Group Hackers. I was so scared and skeptical because I have heard of bad experiences but I decided to give them a try and to my greatest surprise I was able to get all my stolen bitcoins recovered from the scammers within a very short time frame. I don’t know if I’m allowed to share the links on here but you can contact them at wizardcharlesgrouphackers@gmail.com to get help.

    ReplyDelete
  3. After falling victim to a cryptocurrency investment scam, my family and I were left with nothing after these swindlers stole $118,000 total in USDT and Bitcoins from us. We were so lucky to come across a post about Hi.Tech [ hi.techrecovery01@protonmail.com ] a cryptocurrency and funds recovery company with plenty of experience in cybersecurity. Hi-Tech Recovery was able to recover all of our funds, and with the information we provided, they were tracked down and reported to the appropriate authorities. I highly recommend Hi.Tech for your cryptocurrency recovery

    Contact: hi.techrecovery01@protonmail.com
    Telegram: @hitechrecovery

    ReplyDelete