August 13, 2016 at 4:45 pm
In the errorlog I can see the config e.g : clr enabled has been changed from 0 to 1.
How to check who made\ which IP made that change?
August 13, 2016 at 6:50 pm
It should be in the default trace, if it didn't happen too long ago (default trace keeps a limited amount of events)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2016 at 6:55 pm
I was able to find the information from Standard reports\Configuration Change history in sql server 2012.
August 13, 2016 at 7:46 pm
PJ_SQL (8/13/2016)
I was able to find the information from Standard reports\Configuration Change history in sql server 2012.
So, from the default trace. Good.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2016 at 7:53 pm
It was from SQL Server Reports.
August 14, 2016 at 4:59 am
PJ_SQL (8/13/2016)
It was from SQL Server Reports.
And the one you used draws its data from the default trace. (the others query default trace, DMVs or system tables depending on the report)
The point being that there's no where other than the default trace where the info you want is recorded, unless you have custom monitoring.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply