dBforums - View Single Post - Listing 'new' databases

#2 (permalink)

12-02-08, 08:15

shammat

Registered User

Join Date: Nov 2003

Posts: 2,297

What about

Code:

select * 
from sysdatabases
where crdate > getdate() - 1

You will need to adjust the date calculation to your needs