hello im brand new to SQL server but im very well versed in access so i know
how sql works, to aid me in my transition im the microsoft press SQLServer
2000 book and am trying to follow the simple instructions to create a table,
the script is very simple:

use northwind
create table investors
{
IvestorID int not null,
FirstName varchar(30) not null,
LastName varchar(30) not null
}

and ive made sure that ive copied it exactly but its still not working. IM
using the personal edition to get to grips with it before using the one at
work. Im logged in using windows authentication as the user Laptop/Dr patel
which is my username, and should have full database admin rights however i
get the following result when i run the above sql:

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

what am i doing wrong?