November 12, 2014 at 7:13 am
Hi,
Can anyone give me a query to find the date/time when a database schema was created and who created it?
Thanks.
November 12, 2014 at 7:53 am
i don't believe that information is available
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2014 at 10:34 am
It depends what you mean by schema. If you mean a schema object within the database like dbo, there is no direct way to see who and when. If you mean who created a database and when it is in sys.databases and sys.server_principals.
You might be able to infer when a schema was created by getting the min(create_date) for objects in that schema from sys.objects.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply