SQL 2005 Standard.
I wrote a sp that uses ALTER DATABASE instruction. When I execute sp with elevated user it works fine; when I try to execute that sp with a normal user (I alerady gave execute permission for that user) it fails with "alter database failed".
I tried to modify create proc with execute as owner but nothing changed.
How can I do ?
View Complete Post