January 24, 2014 at 10:14 am
It has been reported to me that an effort to rename a table using SP_RENAME on a SQL Server 2012 database (64 bit) is taking hours to complete. The table contains millions of rows of data. I've offered the suggestion to create a new table with the new name, but I've been told that the resources are not there to do that and then populate the new table.
I've searched the web for some insight on what kinds of resources sp_rename uses, but I haven't found anything other than how to use it.
Why would sp_rename present such a problem, and what other options can I consider aside from loading a new table?
Thank you for your help.
CSDunn
January 24, 2014 at 12:01 pm
Shouldn't take that long, the process must be being blocked.
The probability of survival is inversely proportional to the angle of arrival.
January 24, 2014 at 12:44 pm
sturner (1/24/2014)
Shouldn't take that long, the process must be being blocked.
Yes, blocking was the issue. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply