 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / May 2006who dropped my table in SQL Server?
Is there a way to find out which user dropped my table in SQL Server 2000 and when? Thanks. Not necessarily all that easily without knowing when it may have been dropped. Third party log reading tools can give you information on schema changes for whatever logs, log backups you load for the tool to read. Some tools are listed at: http://www.aspfaq.com/show.asp?id=2449 Or ff you were running a trace during the time it may have been dropped....but that's about it on SQL Server 2000. -Sue >Is there a way to find out which user dropped my table in SQL Server >2000 and when? Thanks. Thanks a lot. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.