• Greg Charles (3/18/2008)


    I've been using this query:

    select recovery_model_desc from sys.databases where name = 'master'

    The sys.databases view is in every database.

    I guess you could post your statement in the "Scripts" section. See the navigation list on the left side of the screen.

    Hi Greg,

    Thanks for the reply. Will the script you posted also work under SQL 2000? I am not 100% sure that my script will work under SQL 2000.


    Kindest Regards,

    WRACK
    CodeLake