craeteing temp table in sqlserver 2005

CREATE TABLE #names_sample (
name_id INT IDENTITY(1, 1) NOT NULL,
company_id varchar(50),
full_name VARCHAR(110) NULL,
first_name VARCHAR(50) NULL,
middle_name VARCHAR(50) NULL,
last_name VARCHAR(30) NULL,
suffix VARCHAR(20) NULL
)