I'm trying to add a column to a database. The query has been running for 25mins and it's locking web access to the table and breaking our website:
alter table MyTable add MyNewColumn varchar(max) not null default ('')
The table contains binary data in a different column and is quite large.
Will cancelling by using the red "Cancel Executing Query" button cause additional problems? I'm just trying to figure out if I should attempt to cancel the query at this point, and what will happen since it's been running for so long.