Friday, September 13, 2013

List out last modified procedures and functions in sql server

To List out last modified procedures and functions in sql server

Use below query

 

SELECT name, create_date, modify_date,type

FROM sys.objects

WHERE type IN ('FN','V','P','U','TF')

AND DATEDIFF(D,modify_date, GETDATE()) < 6

ORDER BY modify_date

 

 

Here are different types used in IN clause in WHERE condition:

 

    FN - Scalar valued function

    V - View

    P - Stored Procedure

    U - Table

    TF - Table valued function


If you are searching life partner. your searching end with kpmarriage.com. now kpmarriage.com offer free matrimonial website which offer free message, free chat, free view contact information. so register here : kpmarriage.com- Free matrimonial website