Post reply

SQL server 2000 sysdatabases.status vs equivalent in SQL server 2005/2008

  • February 17, 2009 at 1:07 pm

    #205738

    Hi,

    A want convert SQL 2000 StoreProc to SQL 2005/2008.

    On my original SP, a check the Status bit for trunc. log on chkpt in sysdatabases.status field.

    How I can obtain this information on SQL server 2005 structure?

    Thank's

    dlp

  • February 17, 2009 at 1:55 pm

    #945480

    you will get this information from sys.databases view. and criteria you are looking is more related to recovery model. you can use recovery_model = 1 for your scenario.

  • February 17, 2009 at 2:03 pm

    #945492

    sysdatabases is still supported in 2005, can't offhand remember in sql 2008 as I don't use the backward views/tables. You can certainly find all that info - you could try using the serverpropertyx , a much better way to do this.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 17, 2009 at 2:25 pm

    #945517

    Hi,

    The sys.databases recovery_model field is the right thing I looked for!

    Thank you very much for your help!

    To: SSCrazy, thank's too for the informations!

    Ciao,

    dlp

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply