srinivas_ganamur
asked on
Data is deleted
Hi,
In my current company, some one is deleted data in table. I dont who is delted. I need to find last one month DML/DDl operations in my server/database. So please give me t-sql code to find out last one month operations in serve/databaser with host name (coz all are using sa login)
Please reply ASAP.
Regards,
Sri
In my current company, some one is deleted data in table. I dont who is delted. I need to find last one month DML/DDl operations in my server/database. So please give me t-sql code to find out last one month operations in serve/databaser with host name (coz all are using sa login)
Please reply ASAP.
Regards,
Sri
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
in this i am not recovering deleted data coz it is development server. My question is i want to see what are the commands (DDL/DML/Alter procedure) executed from past 0ne month.
In my opinion (my fellow expert colleagues, please validate/reject this post) this is not possible.
As stated above you can get information about DDL from default trace, but other than that you need to put monitoring in place BEFORE the statements you want to examine/capture. This is because a standard system should not loose capacity due to excessive monitoring.
//Marten
As stated above you can get information about DDL from default trace, but other than that you need to put monitoring in place BEFORE the statements you want to examine/capture. This is because a standard system should not loose capacity due to excessive monitoring.
//Marten
ASKER
Forced to close the question.
you should really redesign your SQL Solution. Look at security aspects, best practise. And maintenance for your databases. Do you backup system databases, user databases, rebuild/reorganize indexes, take log backups, check database integrity and soforth. I feel this is needed to be said in this thread. So there it is!
//Marten