Post reply

Create tables in offline database

  • April 23, 2007 at 3:03 am

    #116563

    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

  • April 23, 2007 at 4:23 am

    #701893

    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]

  • April 23, 2007 at 5:26 am

    #701898

    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