Is there a way to tell who dropped a table?
-
Hi. I've been lurking for some time now, but haven't posted until now. I'm about as green as they come with regard to administration, and I apologize if this is way too elementary question...
We have some tables that were apparently dropped from our development environment yesterday afternoon. Is there a way to tell what user dropped a table?
Thanks for any help,
Dave
Edited by - gambrinus on 06/20/2003 07:59:54 AM
-
There are transaction log viewer utility applications out there that allow you to see thi ssort of information. Lumigent's Log Explorer is one such tool.
-
As far as I know, Log Explorer is the only retroactive way to do this.
Steve Jones
-
This is not exactly full proof but you can check the log to see who was logged into the database at the time, assuming they were logged in under NT authority with a unique user name. Also, if you have a copy of the log, you could try using Log Explorer from http://www.lumigent.com/Products/le_sql/editions.htm that is designed for reading transaction logs. Otherwise, in the future, you need to configure alerts for that type of activity.
Edited by - DALEC on 06/22/2003 06:58:08 AM
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
Content deleted
Edited by - DALEC on 06/21/2003 07:35:18 AM
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
Content deleted
Edited by - DALEC on 06/21/2003 07:35:42 AM
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
Sorry about that.
The browser came up after I posted my first reply and kept asking me to RETRY or CANCEL in order to Refresh the browser. Obviously, I hit RETRY twice and ended up with three postings. I'm so embarrased!
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
The browser came up after I posted my first reply and kept asking me to RETRY or CANCEL in order to Refresh the browser. Obviously, I hit RETRY twice and ended up with three postings. I'm so embarrased! Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply