SQL 2005 Any logs to check the user who modified Database file settings

Question

SQL 2005 Any logs to check the user who modified Database file settings

Lina G

SSC Enthusiast

Points: 180
More actions
January 26, 2010 at 10:43 am

#229385

Hi,
Some one from my team has modified the file growth cap from 10 GB to 15 GB. I would like to know is there a place where I can see the user logged on to modify changes or any view/table/sp will be able to verify the modified change date .
If we make changes to the database/ alter database does it log somewhere. If so where?
Lina G
Lina G
Database Administrator

Viewing 5 posts - 1 through 4 (of 4 total)

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

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 1

If it is 2005+ you should be able to use the schema changes history report, it tells you when and who made database change, it does not tell you what change was made, and the data collected is wiped when SQL is restarted.

Andrew

Lina G SSC Enthusiast Points: 180 More actions · Answer 2

Thanks for the info..

Here is the link I found which explians the need

http://sqlserverpedia.com/blog/sql-server-security/csidba-finding-out-who-made-schema-changes/

Thanks,

Lina G

Lina G
Database Administrator

Steve Jones - SSC Editor SSC Guru Points: 735657 More actions · Answer 3

I'm not sure if the default trace notes this, but you can check there as well.

Lina G SSC Enthusiast Points: 180 More actions · Answer 4

Yes! I think as I tested in one of our lower environment and it works. I think to generate this report we might need sysadmin access. Need to explore on this one.

Lina G

Lina G
Database Administrator