Post reply

single user mode

  • November 20, 2012 at 7:48 am

    #265018

    how to take the sql objects (tables, SP's) in to single user mode in a database

  • November 20, 2012 at 7:54 am

    #1560818

    ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

  • November 20, 2012 at 8:55 am

    #1560862

    ramyours2003 (11/20/2012)

    how to take the sql objects (tables, SP's) in to single user mode in a database

    You can't take objects into single user mode. Only the entire database or the entire instance. Nothing more granular than that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 20, 2012 at 9:44 am

    #1560892

    ramyours2003 (11/20/2012)

    how to take the sql objects (tables, SP's) in to single user mode in a database

    It would be helpful if you could describe what you actually need to accomplish.

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

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