Alter Column on Large Table 40+ million rows - Timeout Error
Pretty straight forward, except for the fact that it times out on the first part when trying to drop the indexes on the current/original table. The database is set to Simple Recovery mode, so I'm assuming limited logging is going on.
Is there a way to increase the timeout period??
Database size is approx 100GB in size, and there is 700GB free space on hard drive.
The error received is below:
The following error message was returned from the SQL Server:
[-2] Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The following SQL command caused the error:
ALTER TABLE [dbo].[OrdersSnapshot] DROP CONSTRAINT [PK_OrdersSnapshot]
The following messages were returned from the SQL Server:
 Dropping constraints from [dbo].[OrdersSnapshot]