Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ralph_jj22022
Starting Member
4 Posts |
 Posted - 2006-07-18 : 07:43:54
|
| hi GurusI have been working on SQL server 2000. I was busy with some queries and sps for the past 2 days. The issue is that this morning when i logged in the sql server, I find the tables and my stored procedures deleted and some manipulated. I don''t know how to retreive back my hard work. However in order to report this issue I want a list of all the queries fired(DDL, DML etc) fired from the SQL Server, so that I can know how the tables were renamed or manipulated on the server. I need to inform you that this is a shared SQL Server instance client that around 7 guys are sharing. Any help is really appreciated.happy coding,Sachin |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-07-18 : 07:57:20
|
| do u have any schduled back. See Weather any backup's avail in ur system. other wise try to recover ur work from ur log file |
 |
|
|
ralph_jj22022
Starting Member
4 Posts |
Posted - 2006-07-19 : 00:44:54
|
| hi and thanks for the reply. I don't think we have any backup for this server since it was a testing server (development server). Regarding the recovering of work from log file...can you guide me how that can be acheived? I have been stuck because I have a meeting with my project manager and the work I have done has gone missing.ByeSachin |
|
|
|
|
|
|
Get a list of queries fired in the past