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 |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2007-08-23 : 10:46:47
|
| Please help...Someone have deleted a table in sql server 2k5 express.HOw can we find the user who have done that.Thanks In ADVANCE...RKNAIR |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-23 : 10:52:45
|
You can do this if1) You have some audit system2) You can find the only user in your organization who are allowed to drop tables3) You can read the error log
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-08-23 : 10:59:28
|
| I dont have a audit system here and many having SA permissions.Error logs not giving any details about Deletion.RKNAIR |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-23 : 11:06:38
|
There are third party log readersOr tryselect * from ::fn_dblog(default, default)
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Urgent