Permission problem execute "DBCC FREESYSTEMCACHE ('All')"


  • if i login with windows authentication i could execute this command

    if i login with sql server authentication i getting the following error

    Msg 2571, Level 14, State 11, Line 1

    User 'system' does not have permission to run DBCC freesystemcache.

    but this user have db__ddladmin and db_owner permissions

    how to grand permission

    11. února 2012 8:36


Všechny reakce