• New Born DBA (10/5/2015)


    Any help on this?

    Have a go at writing a loop to run the query I posted for each DB you have on your server, one thing to look at could be sp_msforeachdb

    Then have a go at joining your query to the #temp table to get the dates for all the databases.

    Post back what you get, will be a good test to develop your T-SQL further.