sql server: create table taking forever!

Question

i am doing this:

CREATE TABLE person
     ( 
        num               INT              NOT NULL  , 
        firstname         VARCHAR(20)          NULL  , 
        lastname          VARCHAR(30)          NULL  
        );

sql server is just saying "debbuging" and it's not doing anything

is there a problem with the syntax or what?

Answer 1

You clicked on the 'Debug' button (green triangle) instead of 'Execute' (red exclamation)? SSMS is waiting on you to step through the T-SQL lines.

Answer 2

Check if there are locks on the database that would prevent SQL Server from executing a create statement. Since you're creating a new table, check for a database-level locks.

Answer 3

i will suggest the obvious...try restarting sql server?