# SQL Server and SQL Express Server

**URL:** <https://forum.kirupa.com/t/sql-server-and-sql-express-server/208971>\
**Category:** programming\
**Created:** [December 4, 2006, 9:25pm UTC](https://forum.kirupa.com/t/sql-server-and-sql-express-server/208971 "2006-12-04T21:25:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RabBell](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/rabbell/32/340_2.png) [@RabBell](https://forum.kirupa.com/u/RabBell)\
**Post date:** [December 4, 2006, 9:25pm UTC](https://forum.kirupa.com/t/sql-server-and-sql-express-server/208971/1 "2006-12-04T21:25:51Z")

</div>

On SQL Server I can create a table and for the primary key it allows me to select AutomatedInt (or something to that effect) and I don’t have to worry about creating unique id’s for entries on the table.

However in Microsofts free version, SQL Server Express 2005, the automated int isn’t an option…

There is a uniqueidentifier field but it doesn’t seem to work like automatedint and it is giving me error messages.

Any ideas?