Forum Replies Created

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

  • RE: Database stuck in single user mode

    Hi,

    use the same session for which you have used to make the database single_user. By default that session will have the access. run the

    Alter database db_name with multi_user command in...

  • RE: Reduce Scan count on tables

    Hi

    Do the update statistics on all tables with fullscan and also check fragmentation of tables using DBCC SHOWCONTIG.

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