July 24, 2012 at 2:34 am
The reorganize index command getting failed with the below error message :
No Alter permissions on namespace , Index xxxx cannot be altered .
The transaction ended in the trigger . The batch has been aborted ( Microsoft SQL Server,Error : 50000) .
Any suggestion on the above please. I have already checked the agent account permissions and that part looks fine.
Please advise.
July 24, 2012 at 2:37 am
Do you have any DDL trigger in your database?
If Yes, then check the code and see if it updates any table to which you don't have permission.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 24, 2012 at 3:07 am
It seems the trigger failed to complete becuase of permission issue. By the way, do you have permission to alter index?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply