how to determine who change the schema ownership?

Question

how to determine who change the schema ownership?

kristoledo

SSC Veteran

Points: 239
More actions
April 10, 2017 at 1:51 pm

#322863

Hi,
I am quite new in SQL Server Administration and we recently have some changes in the schema ownership of our database. Is it possible to determine who did the change by user id?

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

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

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

kristoledo - Monday, April 10, 2017 1:51 PM
Hi,
I am quite new in SQL Server Administration and we recently have some changes in the schema ownership of our database. Is it possible to determine who did the change by user id?

There's a tool in SQL Server called the "Default Trace". It captures things like this an a whole lot more. Here's a Google search link for your particular request.
https://www.google.com/?gws_rd=ssl#q=default+trace+schema+changes

--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)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

On 2012 & better systems, it's a good idea to start looking to extended events for this type of info. There's a system_health extended event that runs, similar to the Default Trace. You can read about it here.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning