April 5, 2012 at 5:01 pm
Hi. I was going through my Sql Server logs in SSMS. I saw these below two operations been implemented on one of our critical databases.
[highlight=#ffff11]"Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database dbVelocityMetadata." [/highlight]
How can I know who performed this activity. I went to sp_readerrorlog. Had no luck.
I went to $D: to check the logs did not find anything.
Where else can I know the person's info who did this. Is Default SQL SERVER Profiler Logs a good place? or anybody has any other ideas on it.
Please help.
Thank you in advance.
April 5, 2012 at 6:47 pm
A change to the ALLOW_SNAPSHOT_ISOLATION database option will not appear in the default trace. A message will however appear in the error log reflecting that the database option was changed, although it will not tell you who made the change, only when and which spid the change occurred on. Example:
Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database database_name.
If you have any other traces running on your system you may be able to correlate the spid to a specific login using the timestamp from the error log, but that would be purely circumstantial. I am not aware of anything generic I can point you towards that would lead you to an answer.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply