Category Archives : MS SQL


MS SQL Error: THE EXECUTE PERMISSION WAS DENIED ON THE…

WHAT When trying to execute a stored procedure in MS SQL Server  with a user-defined type as a parameter you receive an error that reads something like: “THE EXECUTE PERMISSION WAS DENIED ON THE…” WHY The reason you need to supply permission for your defined type is because technically you are trying to access say a “table” […]