Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-10-23 : 03:33:05
|
| Hi,I have seen that there is lock on my entire database and due to that i can not able to perform any DML activities.how can one remove lock from entire database? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 03:47:23
|
| run sp_who2 and see what all processes are causing blocking. then kill them. hopefully this should let you to perform DML activities again. |
 |
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-10-23 : 04:13:39
|
| i have kill processes but still it's not working... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 04:20:31
|
quote:
Originally posted by hirani_prashant
i have kill processes but still it's not working...
how did you kill it? using kill() command? |
|
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-10-23 : 04:23:37
|
| yes using kill() command... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 04:29:44
|
quote:
Originally posted by hirani_prashant
yes using kill() command...
sometimes there are cases where process doesnt actually get killed when using kill(). can you remote login to server and see if process is killed from task manager?http://sqlserver-qa.net/blogs/perftune/archive/2008/05/06/4120.aspx |
|
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-10-23 : 05:03:51
|
| i have done it. still not working.i have seen the procedure sp_lock and it gives me below o/p. might this will help you...spid dbid ObjId IndId Type Resource Mode Status51 5 0 0 DB S GRANT54 5 0 0 DB S GRANT56 5 0 0 DB S GRANT57 12 0 0 DB S GRANT58 4 0 0 DB S GRANT59 12 0 0 DB S GRANT60 5 0 0 DB S GRANT61 6 0 0 DB S GRANT62 5 0 0 DB S GRANT63 12 0 0 DB S GRANT64 4 0 0 DB S GRANT66 12 0 0 DB S GRANT66 2 34 0 TAB IX GRANT66 2 34 2 KEY (a616a875b47f) X GRANT66 2 99 0 RID 1:235:1 X GRANT66 2 34 2 KEY (0501c29022f9) X GRANT66 2 99 0 RID 1:235:2 X GRANT66 2 142623551 0 TAB Sch-M GRANT66 2 34 1 KEY (3f00f4eb7731) X GRANT66 2 34 3 KEY (a61641ea6216) X GRANT66 2 34 3 KEY (050139f31e71) X GRANT67 1 1115151018 0 TAB IS GRANT67 12 0 0 DB S GRANT69 5 0 0 DB S GRANT70 5 0 0 DB S GRANT71 5 0 0 DB S GRANT72 5 0 0 DB S GRANT73 12 0 0 DB S GRANT74 12 0 0 DB S GRANT75 12 0 0 DB S GRANT76 12 0 0 DB S GRANT77 12 0 0 DB S GRANT78 12 0 0 DB S GRANT79 12 0 0 DB S GRANT80 12 0 0 DB S GRANT81 5 0 0 DB S GRANT82 12 0 0 DB S GRANT84 12 0 0 DB S GRANT85 5 0 0 DB S GRANT86 12 0 0 DB S GRANT87 12 0 0 DB S GRANT88 12 0 0 DB S GRANT |
|
|
|
|
|
|
lock on entire database....