Rajib Bahar's Blog

Rajib blogs here about topics of his interest.

The EXECUTE permission was denied on the object 'sp_ssis_addlogentry'

August 07
by Rajib Bahar 7. August 2012 05:51

I have been lazy about blogging for a long long long time... I thought I'd get back into it again with an error message. Depending upon a project, I either get full-admin privilege or restricted privilege. Both options have merit, but, I prefer more flexibility in anything I do. This particular error message is very trivial. I'll not be breaking any ground by saying the solution is to grant proper permission. We often run into this kind of permission issues whenever dealing with database objects. It happens whenever the user lacks permission to utilize an object. How did I run into this error? I usually prefer storing ssis logging data in a table. One of these days, I'll get motivated to write my own custom solution. Until then I find the built-in logging mechanism sufficient. In most ssis projects, I had the privilege to utilize sp_ssis_addlogentry object. I didn't have to worry about setting that permission. When this issue arose I had to get help from our dba Jimit Mehta. He's a dba-super-hero for our team. As soon as he ran the statement below, my headache was gone. 

 

 

grant execute on sp_ssis_addlogentry to [domain_name\user_name]

 

MS SQL Server 2008 Debugging

January 15
by Rajib Bahar 15. January 2009 21:20
I like the new debugging capabilities of SQL Server 2008. It brings in features such as stepping in, stepping out, and stepping over. This can come handy when we are trying to track the actual issue. I found this feature interesting because it empowers developers to track issues at the most granular level. Now, we can step inside system functions, and stored procedures to figure out the values of internal variables and sets. See the video below for a quick guide on how to debug in SQL Server 2008 management studio.