The EXECUTE permission was denied on the object 'sp_ssis_addlogentry'

By Rajib Bahar at August 07, 2012 05:51
Filed Under: Database, SQL, SQL Server

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]

 

Trend

By Rajib Bahar at October 11, 2009 10:37
Filed Under: SQL, Interesting, .NET
It's a challenge to keep track of things as they are constantly changing (just like my tools of the trade). Don't you wish you are always on top of all things, but, other things in life get in the way... Some time I get immersed in work and study that I forget the rest of the world. 

Now, that I have this challenge at hand, the question is how am I going to pull myself through this one? I found a tool on it's face seemed quite interesting. My work involves working with SQL server. If I want to learn the noise around sql server then it will show what everyone in the world is thinking about it. I believe it utilizes the RSS feed from twitter. The people at codemunch.com wrote this very simple and useful tool (depending upon your value on it). I found their site while trying to find the trend on sql server. 

How to use it?

Here is what the URL for the trend on "SQL Server" would look like. 


Simply change the "q=" part to your preferred query. For example, you want find the latest on sql then the query string would look like "q=sql". If you want to use words with spaces in it then place a %20 between each word. It's as simple as that.

Other trends that I may use for myself include:

I am sure other Gurus may have different opionion how to find trend. After all, there are other reliable methods such as reading the book on latest tools, online articles, blogs, visiting focus groups that provide training in similar area. My intention with this entry is to talk about what other tool is out there to complement such effort. Anyways, I do find the existing methods useful from time to time. I have been to the local sql server user group many times. Most of the times, I went their for the swags, and free softwares. Most recently, I went to the "SQL Server Summit" hosted in minnesota with sponsorship from Digineer. I attended one of the reporting services session to learn about the challenges the MVP had in his project. Toward the end, I asked a question about SSRS and sharepoint and got good feedback from several peers. The presenter moved on to take other closing questions. In the meantime, I had this urge to tinker. I took out a yo-yo which I picked up from Digineer's booth prior to that presentation. I thought I'd play with it while the presentation ends. Unfortunatley, I did not know that the yo-yo's extra feature included very loud sound, and shiny lights. Yes, it was an awkwardly funny moment and all eyes were on me. I was in a panic mode trying to silence the alarm. Luckily for me, I did not get bounced out as I worked with some of the people in there running the show. I had an occassion to collaborate with Mark V. from digineer in the past. He was sitting next to me and cracked open. He did not know that the yo-yo would do that. I am making a note to avoid yo-yo's next time. BTW, I transferred the yo-yo to my nephew, but, I digress.

MS SQL Server 2008 Debugging

By Rajib Bahar at January 15, 2009 21:20
Filed Under: SQL
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.

My YouTube VLOG

By Rajib Bahar at December 13, 2008 22:16
Filed Under: SQL

I have 2 YouTube Video Log or VLOG.

One is work related and called the icsql channel. The clip below talks about SSIS script component changes:

My other VLOG is related to art and volunteer works I do around the community. I volunteer some of my free time to KFAI radio these days. Here is a radio interview I did with some notable friends like Matt Harding, Palbasha Siddiqui, and Garry Schyman:

 

Tag cloud

Month List