Create tables in offline database

  • Hi All,

    Can we create a table or can we do any modifications in a database that is in Offline Mode.

    Thanks in Advance

    Koti

  • From BoL:

    "By placing the database offline, users are prevented from accessing the database, and no modifications to the database can be made until the database is placed online."

    May I ask, why are you trying to alter a database offline? If it's just to prevent user access to the database at the time you could remove all permissions to the database apart from your own?



    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • If the last suggession is right then yucan use:

    ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    ... Some actions ...

    ALTER DATABASE [MyDatabase] SET MULTI_USER

    _____________
    Code for TallyGenerator

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

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