SELECT
    'U'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE) 
FROM sys.tables
WHERE create_date > '2013-01-01'
UNION        
SELECT
    'V'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE) 
FROM sys.views
WHERE create_date > '2013-01-01'
UNION 
SELECT
    'P'
,    [name]
,    CAST (create_date AS DATE)
,    CAST (modify_date AS DATE) 
FROM sys.procedures
WHERE create_date > '2013-01-01'
ORDER BY [name]
Thursday, July 18, 2013
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment