USE [YOUR DATABASE NAME HERE]; GRANT EXEC ON dbo.[YOUR OBJECT NAME HERE] TO PUBLIC
https://stackoverflow.com/questions/3708348/the-execute-permission-was-denied-on-the-object-xxxxxxx-database-zzzzzzz-s
The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'
I'm having problems executing a function. Here's what I did: Create a function using SQL Server Management Studio. It was successfully created. I then tried executing the newly created function and
stackoverflow.com