Click here to Skip to main content
13,049,814 members (71,674 online)
Click here to Skip to main content
Articles » Database » Database » General » Revisions

Tagged as

Stats

11.8K views
11 bookmarked
Posted 18 Feb 2010

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
5 - publicly available No 22-Feb-10 18:00 Available Gaurav Dudeja India
3 No 18-Feb-10 0:48 Composing Gaurav Dudeja India
2 No 18-Feb-10 0:46 Composing Gaurav Dudeja India
1 No 18-Feb-10 0: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.

You may also be interested in...

Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170713.1 | Last Updated 23 Feb 2010
Article Copyright 2010 by Gaurav Dudeja India
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid