skip to main | skip to sidebar

The all purpose blog

Tuesday, October 4, 2011

Find Modified Procedures,Functions,Views In SQL Server

 /*
Below code is for SQL 2008
*/
SELECT 'EXEC sp_HelpText '+name, create_date, modify_date,type
FROM sys.objects
WHERE type in ('P','FN','V','TF')
AND DATEDIFF(D,modify_date, GETDATE()) < 10 --How old the object can be ?
ORDER BY modify_date


Posted by Mahmad Khoja at 6:45 PM
Labels: function, Sql Server, stored procedure, view

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2011 (14)
    • ►  December (2)
    • ▼  October (6)
      • Get selected values of checkbox from GridView in A...
      • Circular matrix in vb.net
      • Get selected checkbox value of ASP.NET GRID VIEW ...
      • Find post back control with JavaScript
      • SQL Code to generate properties for vb.net
      • Find Modified Procedures,Functions,Views In SQL Se...
    • ►  September (4)
    • ►  August (1)
    • ►  February (1)
  • ►  2010 (8)
    • ►  April (1)
    • ►  March (5)
    • ►  February (2)
  • ►  2009 (39)
    • ►  October (8)
    • ►  September (2)
    • ►  August (2)
    • ►  July (2)
    • ►  May (1)
    • ►  April (5)
    • ►  March (14)
    • ►  February (4)
    • ►  January (1)
  • ►  2008 (69)
    • ►  December (5)
    • ►  November (8)
    • ►  October (9)
    • ►  September (9)
    • ►  August (38)

About Me

Mahmad Khoja
Khoja Mahmadhusen.A Software Developer (BCA,MscIT,MCP 2.0).
View my complete profile