Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Database SQL Server2008 StoreProcedure Locked Issue

database storeprocedure locked sql server how to unlock sql store procedure unlocked

This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1 jiqbal0082

jiqbal0082

    CC Lurker

  • Just Joined
  • Pip
  • 2 posts

Posted 01 August 2013 - 10:44 AM

Database SQL Server2008 StoreProcedure Locked Issue, 

 

 

some of my database store procedures are locked , how can unlocked these .

 

 

 

screen shot is attached , please see it too .

 

 

 

 

Regards

 

Attached Thumbnails

  • Locked Store Procedure.jpg


#2 Luthfi

Luthfi

    CC Leader

  • Expert Member
  • PipPipPipPipPipPipPip
  • 1320 posts

Posted 01 August 2013 - 10:51 AM

There could be one (or more) of these reasons:

  • Those stored procedures are encrypted
  • Those stored procedures are CLR stored procedures
  • Current user doesn't have permission to view their definitions

 

Find out which of these are your problems.



#3 jiqbal0082

jiqbal0082

    CC Lurker

  • Just Joined
  • Pip
  • 2 posts

Posted 01 August 2013 - 11:05 AM

on right clicking at storeprocedure modify option is disable .  if u see pic there is lock sign at locked store procedure.



#4 Luthfi

Luthfi

    CC Leader

  • Expert Member
  • PipPipPipPipPipPipPip
  • 1320 posts

Posted 01 August 2013 - 11:24 AM

I saw that, and I already gave you the possible reasons of your problem. It is your responsibility to find out which reason caused that problems, and deal with it.

 

If you are the one who created them, are you sure you did not encrypt them? Could you check the current user privilege against them?


Edited by Luthfi, 01 August 2013 - 11:24 AM.


#5 BlackRabbit

BlackRabbit

    CodeCall Legend

  • Expert Member
  • PipPipPipPipPipPipPipPip
  • 3871 posts

Posted 01 August 2013 - 11:44 AM

Try what luthfi said, and then my question: is that database your company's ? are many people working on it, as in coding?

 

It could also happen it's on certain kind of source control and there's another guy working on it, or worst case, it might be running and being in a deadlock






Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download