Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Revisions
 
Add your own
alternative version

Tagged as

Some internal SQL Sever Queries

, 22 Feb 2010
The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days.SELECT name AS object_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_dateFROM sys.objectsWHERE modify_date >...

Revisions


  

Compare Revision Minor Date Status Editor
publicly available No 23-Feb-10 0:00 Available Gaurav Dudeja India
3 No 18-Feb-10 6:48 Composing Gaurav Dudeja India
2 No 18-Feb-10 6:46 Composing Gaurav Dudeja India
1 No 18-Feb-10 6:46 Composing Gaurav Dudeja India

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Gaurav Dudeja India
Technical Lead Samsung India Electronics Pvt. Ltd.
India India
Gaurav Dudeja has done B-Tech from ABES Engg College, Ghaziabad, Uttar Pradesh, India . He is an interested, committed, creative Software professional having more than 3 years of solid experience in web-based and windows based solutions in Microsoft Technologies using .NET 2.0, .NET 3.0 , .NET 3.5, ASP.NET 2.0, ASP.NET 3.5 C# 2.0, AJAX, Web Services, MS SQL Server 2005, WSS (Windows Sharepoint Server 3.0 ). He is also an MCP (Microsoft Certified Professional) and MCTS (Microsoft Certified Technology Specialist) on Web Development (.NET 2.0 ). He has good knowledge of Object Oriented Programming, 3-Tier Architecture and Design Patterns as well as good command over IIS (IIS 5.1,IIS 6.0, IIS 7.0) and deployment of Application on Live Production Environment.
Follow on   Twitter   Google+   LinkedIn

| Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 23 Feb 2010
Article Copyright 2010 by Gaurav Dudeja India
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid