Home Forums SQL Server 2008 T-SQL (SS2K8) Trying to bypass via tsql a database when it is offline RE: Trying to bypass via tsql a database when it is offline

  • September 4, 2013 at 12:26 pm

    #1647447

    Try this:

    IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

    BEGIN

    ...

    END

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.