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 |
|
Jawad
Starting Member
17 Posts |
 Posted - 2012-09-03 : 10:22:28
|
| HiSQL Server 2005 & 2008I don't have permissions on 'sys.dm_db_index_usage_stats'Is there any other way I can find last DML(Insert, Update, Delete) date of my own table(s) with in limitations of my own user account?WishesJ a w a d |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-03 : 15:09:02
|
| do you've an audit table setup? or CDC in 2008?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Jawad
Starting Member
17 Posts |
Posted - 2012-09-04 : 00:17:03
|
quote:
Originally posted by visakh16
do you've an audit table setup? or CDC in 2008?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
No audit table and my major part of work is in SQL Server 2005. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-04 : 01:18:50
|
| Some ideas 1)What is your intention? For example , if it's to find out the last time you logged on - you may be able to request a Security Audit readout from the Event Viewer. 2)Find the tables you think are used , do they have a timestamp column?3)http://blogs.msdn.com/b/jenss/archive/2009/11/18/want-to-know-what-happened-on-your-database-by-reading-the-transaction-log.aspxJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
How To Find Last DML Operation Date Of Table