last modified on database detail



SELECT
    modify_date
        ,type_desc
        ,name
    FROM sys.objects
    WHERE is_ms_shipped=0
        --AND modify_date>='yyyy/mm/dd'  <--optionally put in your date here
    ORDER BY 1 DESC

Comments

Post a Comment

Popular posts from this blog

To send automatic email window  services http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-ii/
Read more
Cart URL http://demo.opencart.com/admin/index.php?route=catalog/product&token=e1ce5583d537727fce5af2d43e894c50   http://www.cs- cart .com/demo- item.html http://discover.store.sony. com/tablet/#specs/diagram   http://www.bit- cart .com/ shopping- cart -live-demo.html
Read more
Difference Between  @@identity , scope_identity() and ident_Current('tablename'):-  SELECT @@IDENTITY @@IDENTITY is limited to the current session, it is not limited to the current scope. SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT(‘tablename’) IDENT_CURRENT is not limited by scope and session; it is limited to a specified table.    
Read more