Object info ?
It's the possible to see which object (table,view,proc) used (not changed) in last year?
Thanks.
[172 byte] By [MirzaT] at [2008-2-15] 
It's the possible to see which object (table,view,proc) used (not changed) in last year?
Thanks.
No, SQL Server does not automatically contain such information. You will need to have a trace running to record which objects are used, but to trace for a year would probably be a bit extreme.
ChrisHedgate at 2007-9-9 >
This does not come for free, but can be done.
You can use DDL triggers to create custom logging of DDL changes, also there is a constant lightweight trace for SQL Server 2005 that tracks DDL changes, but this rolls over at 100MB based on file size, so you would have to extract data from this file frequently to prevent its loss.
There is a report in SSMS that shows you latest DDL changes in this file.
-Euan
EuanGarden at 2007-9-9 >
SQL Server Hot Topic
- Connecting to SQL Server with a login form.
- Can't debug DataFlow Script task
- Visual Studio 2005 Beta 2: Using SQL Server 2000 instead of SQL Express 2005
- ODBC Destination in SSIS
- Timeout expires when deploying assemblies in SQL Server 2005 June CTP
- TargetServerURL for named instance?
- array as parameter for IN statement
- Variables Not Seen In Custom DataFlow Destination
SQL Server New Topic
- CellSet.get_Item peformance degradation
- DCR: Get task elapsed time in dtexec output
- Use an Expression to set the Password of a Connection
- Error creating ssis package job step
- ANN:Dundas Chart for Reporting Services now in Beta
- OLE DB Destination issue in ForEach Data Flow
- [Time].&[2007].&[2] vs.[Time].[2007].[SEMI2]
- Modifying graph range
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
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
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc