Listing 'new' databases

andrew.thompson · #1 (**permalink**) 12-02-08, 07:05

I'm looking for a script / SQL Agent job I could schedule that will flag up when a 'new' database has been created on some of our servers. One of the applications we run can create these -- but I need to do some 'housekeeping' on these servers as they don't have much spare space.

shammat · #2 (**permalink**) 12-02-08, 07:15

What about

Code:

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

You will need to adjust the date calculation to your needs

andrew.thompson · #3 (**permalink**) 12-02-08, 10:46

Thank you -- it works a treat !