question

SaiVijaya avatar image
SaiVijaya asked

How to find who created new database in sql server 2017

I have seen new database in my server. that was created nearly 45 days back. I have tried to check using standard report but no luck.

SQL version: SQL server 2017 enterprise.

Is it possible to find who created database and from which system it was created?

sql2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

Unless someone has changed the ownership of the database, the database owner will match the login that created it

select suser_sname(owner_sid),name from sys.databases
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.