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 |
|
Soumen Dey
Starting Member
20 Posts |
 Posted - 2005-07-18 : 04:15:48
|
| HI,I'm working on a database, I have all the rights. on the database. but I cannot drop or delete a particular user defined table.But I can perform any operation on all other user defined tables. Is there any sp_ to find out what is the problem with the table.Soumen |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-07-18 : 04:20:06
|
what's the error you're getting?Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-18 : 05:03:36
|
| Make sure you have permissions to do soMadhivananFailing to plan is Planning to fail |
|
|
|
Soumen Dey
Starting Member
20 Posts |
Posted - 2005-07-18 : 05:55:35
|
| When I'm trying to modify that particular table the system is getting hung. It is taking a lot of time.Is there any stored procedure to monitor the activities of that particular tableSoumen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-18 : 06:40:19
|
| How many data does that table have?Post the table structure and the queryMadhivananFailing to plan is Planning to fail |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-07-18 : 07:35:15
|
| "modify that particular table the system is getting hung"....'hung and NEVER comes back' or 'hung and comes back when I cancel the modify"...which is it?"Is there any stored procedure to monitor the activities of that particular table"...no..but PROFILER can show what SQL Activity is going on within a defined session.What are you using to modify the table....please don't say EM!!If you are modifying the table via code....in a QA session (as you should be) then post the code.Is the table being modified "large"?Does it have triggers? |
|
|
|
Soumen Dey
Starting Member
20 Posts |
Posted - 2005-07-18 : 07:44:56
|
| The table has 21000 records there are no trigerrs or sp but only primary.It does not allow to execute any DML statementSoumen |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-07-18 : 11:26:23
|
| It sounds like a persistant Schema Stability lock. While you are trying to drop tha table, check the output of sp_who, to see if your drop is getting blocked. |
|
|
|
|
|
|
Very urgent please respond...........