Post reply

DBCC command won't execute with db_owner role

  • November 2, 2009 at 4:28 pm

    #213167

    Hi,

    I have recently migrated a database from 2000 to 2005. In 2000, the user had db_owner on the database, and could execute DBCC commands. In 2005, the same user has db_owner access, but is unable to execute the commands without being sysadmin.

    Can someone please advise?

    thanks.

  • November 4, 2009 at 5:39 pm

    #1075102

    Hi,

    This may have something to do with new behavior of the DBCC CHECKDB, which creates internal snapshot of the database. To disable snapshot creation, specify WITH TABLOCK option, but then you will have locking on tables, like you had in SQL 2000.

    How do you connect to the database you want to DBCC? Do you use EXECUTE AS/REVERT?

    Regards

    Piotr

    ...and your only reply is slàinte mhath

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

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