SQL SERVER SPECIALIST

This Blog provide you the knowledge regarding DBMS and RDBMS.Specially for SQL SERVER and Oracle. Thanks A Lot .......for your cooperation and support.

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
Posted by Surender Kundu at 05:05
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

Blog Archive

  • ►  13 (1)
    • ►  March (1)
  • ►  12 (2)
    • ►  January (2)
  • ▼  11 (72)
    • ►  August (10)
    • ▼  July (17)
      • Step by Step Log Shiping Configuration
      • Newly created SQL object Details for last Week
      • Find out any Login created or updated in last week
      • find out New created Maintanance plan&Jobs in week
      • Backup time details for database in Sql Server
      • 'TOP TABLES IN EACH DATABASE in Sql Server
      • 'SPACE DETAILS OF DATABASES' in Sql Server
      • Sql Server Database Backup types :
      • Sql Server DBA Interview questions
      • Attach Database with MDF file only
      • How to attach and deattached database in sql serve...
      • How to move database physical_files from one drive...
      • SQL EXERCISE Retrieve the required information us...
      • Sql Server Table and Index Architecure
      • Sql Server Physical Architecture
      • BAsic sql Commands and Constaint creation
      • How to find out constraints on table with column?
    • ►  June (45)

Popular Posts

Articles

  • Home

Search This Blog

Total Pageviews

Simple theme. Theme images by MadCircles. Powered by Blogger.