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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Search tables in which there were changes

Author  Topic 

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2014-07-16 : 01:10:07
Good day. Tell me how to calculate the tables in which, for example, there is a record for the last 20-30 minutes? The database consists of tables, functions, triggers, and ensures that itd program for the design of complex and large objects, such as plants.

http://sql-az.tr.gg/

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-16 : 07:46:17
Check out this article: http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/
Go to Top of Page

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2014-07-17 : 02:43:16
thanks
but my server mssql server 2000
have equivalent sys.dm_db_index_usage_stats in sql 2000?

http://sql-az.tr.gg/
Go to Top of Page
   

- Advertisement -