EXECUTE permission denied in SqlServer

Open SqlServer ---> Select DataBase --> RightClick --> Click on Properties


Permission1.JPG

Image 1.

By clicking on Properties A Dialog box will appear like

Permission2.JPG

Image 2.

Here Select Permission and checked Execute Option and click on OK.


Next Recommended Reading Rename a table in sqlserver 2008