Wednesday 20 July 2011

Newly created SQL object Details for last Week

PRINT '=========================='
PRINT '     SQL objectDetails    '
PRINT '=========================='
select CONVERT(VARCHAR(35), name)"Name" ,xtype , crdate from  sysobjects  where crdate >= getdate() -7

No comments:

Post a Comment