Stephen,
I don't think that SQL is creating a PRIMARY KEY ... you need to have a constraint defined as follows:
ALTER TABLE depappl ADD CONSTRAINT
PK_ap_key PRIMARY KEY CLUSTERED
( ap_key )
GO
~~Bonnie
>Kevin, Trust me EVERY table has a xx_KEY:
>
>
>CREATE TABLE [dbo].[depappl] (
> [ap_key] [int] IDENTITY (1, 1) NOT NULL ,
>
>)
> ON [PRIMARY]
>GO
>
>I added it into the Select statement just to passify a need for a key. It bombed without a reference to it too.
>
>__Stephen
>