# Insert Record Error MS SQL2000

**URL:** <https://forum.servoy.com/t/insert-record-error-ms-sql2000/152>\
**Category:** Classic Servoy\
**Created:** [June 19, 2003, 5:40pm UTC](https://forum.servoy.com/t/insert-record-error-ms-sql2000/152 "2003-06-19T17:40:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpwiedemann](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mpwiedemann](https://forum.servoy.com/u/mpwiedemann)\
**Post date:** [June 19, 2003, 5:40pm UTC](https://forum.servoy.com/t/insert-record-error-ms-sql2000/152/1 "2003-06-19T17:40:25Z")

</div>

Hello,

I have a simple table that has an auto incremented primary key. I have set the Servoy dataprovider PK to ‘managed by database’. I keep getting this error when creating a record.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ‘,’. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ‘,’.

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [June 20, 2003, 4:08am UTC](https://forum.servoy.com/t/insert-record-error-ms-sql2000/152/2 "2003-06-20T04:08:03Z")

</div>

The primary key has to be managed by Servoy, you can have other auto increments be managed by the database but not the primary key. There is no generic way to get database increments back through JDBC currently so we can’t support PK’s managed by the database. We are looking at implementing database specific routines to be able to support this functionality.

---

<div class="post-metadata">

**Author:** ![mpwiedemann](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mpwiedemann](https://forum.servoy.com/u/mpwiedemann)\
**Post date:** [June 20, 2003, 5:52am UTC](https://forum.servoy.com/t/insert-record-error-ms-sql2000/152/3 "2003-06-20T05:52:27Z")

</div>

Thanks Jan.