SQL 2019 Standard - DB role, how to find create date and who created it.

Question

SQL 2019 Standard - DB role, how to find create date and who created it.

Warren Peace

SSCertifiable

Points: 5881
More actions
January 19, 2023 at 6:50 pm

#4139686
A role has appeared on a few databases. Is it possible to find ~~when it got created and~~ who created it?
In SSMS it does not show those properties.
Viewing "Facets" get's me the date but need to know by who created it.
Also looking at Schema history returns nothing.

Thanks
- This topic was modified 1 year, 11 months ago by Warren Peace.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

If you know the date the principal was created AND you have a log file that spans that date, you can find it in the log file. I don't have the specific code to so so but Paul Randall explains how to do it at the following link.

https://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

Since you're using 2019, you should not have the "hidden SQLOS scheduler" problem that was fixed in 2012 SP2.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)