Primary Key problem in db transfer Access to SQL server

I have an application initially made with Cold Fusion and Access.
I have transferred the db from Access to SQL Server and all the code works fine except for the INSERT statement. SQL Server does not generate an automatic primary key... 'o( any ideas?what was an autonumber in access is an IDENTITY column in sql/server

if you are doing INSERT statements, you do not mention the identity column (same as in access)

if you need to preserve the numbers that existed in the access tables, you can do that (look up the bcp utility and BULK INSERT KEEPIDENTITY in Books Online)

rudy
http://rudy.ca/|||Thanks!

Primary Key

HI, im tying to import data in a table from my AS400 the transfer is fine but
when i want to set a primary key to do relationship it keep telling me that I
have duplicate key how can I remove the duplicate key.
Thanks!
O i forgot im a reel dummies in SQL2000
INF: How to Remove Duplicate Rows From a Table
http://support.microsoft.com/default...b;en-us;139444
AMB
"Jean-Francois" wrote:

> HI, im tying to import data in a table from my AS400 the transfer is fine but
> when i want to set a primary key to do relationship it keep telling me that I
> have duplicate key how can I remove the duplicate key.
> Thanks!
> O i forgot im a reel dummies in SQL2000

Primary Key

HI, im tying to import data in a table from my AS400 the transfer is fine but
when i want to set a primary key to do relationship it keep telling me that I
have duplicate key how can I remove the duplicate key.
Thanks!
O i forgot im a reel dummies in SQL2000INF: How to Remove Duplicate Rows From a Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;139444
AMB
"Jean-Francois" wrote:
> HI, im tying to import data in a table from my AS400 the transfer is fine but
> when i want to set a primary key to do relationship it keep telling me that I
> have duplicate key how can I remove the duplicate key.
> Thanks!
> O i forgot im a reel dummies in SQL2000

Primary Key

HI, im tying to import data in a table from my AS400 the transfer is fine bu
t
when i want to set a primary key to do relationship it keep telling me that
I
have duplicate key how can I remove the duplicate key.
Thanks!
O i forgot im a reel dummies in SQL2000INF: How to Remove Duplicate Rows From a Table
http://support.microsoft.com/defaul...kb;en-us;139444
AMB
"Jean-Francois" wrote:

> HI, im tying to import data in a table from my AS400 the transfer is fine
but
> when i want to set a primary key to do relationship it keep telling me tha
t I
> have duplicate key how can I remove the duplicate key.
> Thanks!
> O i forgot im a reel dummies in SQL2000