![]() When I attempt to rename the table with sp_rename I see the spid of the process that is blocking the rename in sys.sysprocesses, but for some reason I cannot figure out how to clear out the blockage. Something has to be hanging it up but I don't know what. ![]() ![]() Anyway, I ran your query, and the only things that comes up is query I ran on the sys.dm_tran_sessions_transactions table which was started well after I started experiencing difficulties yesterday. Finally, as a last resort I decided to drop the table since this was just a history table on a development database but that didn't even want to go through. Then I attempted to rename the old table to keep it as a back up, but I found it wouldn't even do that. Then I inserted the data over to this new table which worked. That said, when it was taking too long I canceled the query and then I thought to create a temp table with the columns in the correct format. The table has about 26k rows, and I was attempting to just alter the type of two columns in place. The original problem came about when I tried to alter columns with an ALTER directly, not through SSMS. Am I looking in the correct places? Also this occurred after I canceled a long running query where I was attempting to change a column from varchar(max) to text on the table in question. Sys.dm\_exec\_requests but nothing looks to be an obvious culprit. (Microsoft SQL Server, Error: 1222) For help, click: ![]() Either the parameter is ambiguous or the claimed (OBJECT) is wrong. () - Lock request time out period exceeded. The lock timeout is in milliseconds that waits for a backend resource to. ((SQL_PreRelease).080709-1414 )
0 Comments
Leave a Reply. |