Can I view a Log of any changes made on our database? - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Can I view a Log of any changes made on our database?

Can I view a Log of any changes made on our database?

Options · View

Previous Topic · Next Topic

bbacarat

Posted: Thursday, January 28, 2010 4:03:51 PM

Rank: Newbie
Groups: Member

Joined: 1/28/2010
Posts: 1
Points: 3
Location: Manchester

I've recently had one of our web design customers come to us stating that their emails are not coming through from a lead generation form that they have setup to track national television advertisement responses to. This company took one of our employees on as their own SEO/Marketing director and I have since found out that he has accessed the database.

Is there anyway to track what changes he may have made to the database? I'm not a .net developer but know a little bit about databases. I've looked around for a log file but can't spot anything?

elian

Posted: Monday, February 01, 2010 8:24:42 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

There is no log file that could help you.
If ever you want to find changes he could have made to the schema of the db, there are some "db compare" tools that could help you. We recommend Red Gates ones: http://www.red-gate.com/

(also, do not forget to change password to access the db...)

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » Can I view a Log of any changes made on our database?

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.