i am using microsoft sql-server 2008 for creating database tables... I am using the following commands to create the table. but it is giving the syntax error 
incorrect syntax near `AUTO_INCREMENT`

code:

```
CREATE TABLE products
(
ID int NOT NULL AUTO_INCREMENT,
Name NOT NULL varchar(255),
Description varchar(255),
PRIMARY KEY(ID)
);

```

error:

```
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'AUTO_INCREMENT'.

```

What is the problem here?