0

SQL Server 2014 Std Edition

We add columns all the time, and the ALTER TABLE commands return instantly.

E.g.

alter table [dbo].[Account] add ChildAccount nvarchar(100) NULL
GO 

But at the moment, this alter table seems to run forever.

What would cause this?

1
  • 1
    Did you check for blocking ?
    – Kin Shah
    Sep 9, 2016 at 12:23

1 Answer 1

1

Yes, some other session was blocking. A few min later, this command executed instantly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.