In mssql you need to set the indentity property of an integer column. The seed and increment are 1 by default. In Enterprise manager go into the table designer and the options are available.
If you are creating tables via an SQL client, the syntax for the column is
[Column Name] [int]...