My problem is that when I try to shrink the Log it works when I am logged in as SA but when I log in as a "normal" USER it does not shrink the log. (SQL Express 2008r2)
I have tried to find a answer to my problem but I cant. So please help me! =)
This question came from our site for professional and enthusiast programmers.
The last thing you want is allowing a normal user to run DBCC SHRINKxxx
This should be reserved for highly privileged users to run in a few rare circumstances. This should not be a regular or normal operation.
If you really want to run this because you know better, then use a stored proc with EXECUTE AS
|show 2 more comments|
Regular user have no permissions to do maintenance tasks. If you want the regular user to perform these tasks - add him to fixed server role sysadmin or make him a db_owner of the DB
For details see here: DBCC SHRINKFILE