Fix the stinking ‘EXECUTE permission was denied on the object’ error

So you’re building stored procedures? Sweet. You have to set the stored procedure permissions though. I kept forgetting how to do this when I started implementing stored procedures. This is for SQL Server Management Studio Express 2005. It’s probably a little different on other version.

1. Open SQL Server Management Studio Express 2005

2. Expand your database > expand Programability > right click and select Properties

3. Select Permissions

4. Add desired user to ‘Users or roles list’

5. Select Grant on the Execute row of the ‘Explicit permissions’ menu.

I wish I had a brain…