converting mysql 2 sql 2000

hi

im new to sql 2000 but have previously used mysql

can anyone help me to convert the following script ???


DROP TABLE IF EXISTS cat;
CREATE TABLE cat (
id int(11) NOT NULL auto_increment,
enabled enum('Y','N') NOT NULL default 'Y',
name char(20) NOT NULL default '',
def enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (id)
);

INSERT INTO cat VALUES (1,'Y','Not Categorised','N');

ALTER TABLE cat AUTO_INCREMENT = 5;

the problems are with auto-increment and inserting the record
ive tried using IDENTITY but cant get it working.

please can someone give me some tips