Sander,
You can use Table Designer to make change but instead of applaying it, genereate SQL script. See
http://www.winnetmag.com/SQLServer/Article/ArticleID/22080/22080.html>I need a SQL-script to change my table. Right now I have a integer data field (id). This field is the primairy key in my table, but right now it has't an autoincrement function.
>
>How can I change my table to change this integer field into a IDENTITY field with an increment of 1, without using the table designer?
>
--sb--