Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server XML

SQL object info?


It's the possible to see which object (table,view,proc) used (not changed) in last year?
Thanks.
[114 byte] By [MirzaT] at [2008-1-23]
«« VB6 and CCW's
»» Object info ?
# 1
The catalog view sys.objects

SELECT * FROM sys.objects

contains a column called modify_date that gives the date of last modification of the database objects. sys.objects includes tables, views, procedures, and so on, but some new objects introduced in SQL Server 2005 (e.g. XML schema collection) are not included.

Hope this helps.

Shankar
Program Manager
Microsoft SQL Server

ShankarPal at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server XML...
SQL Server
SQL Server XML

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified