Hello!

I have the follows problem: A stored procedure creates a temporary table with primary key constraint

CREATE PROCEDURE A
AS
BEGIN
CREATE TABLE #A
(
ID INTEGER
)
ALTER TABLE #A
ADD CONSTRAINT
A_ID_PK PRIMARY KEY (ID)
END

If various connections run this stored procedure at the same time, i get the error message like "A primary key constraint A_ID_PK already exists!"

Is it possible to create a TEMPORARY primary key constraint within a temp. stored procedure?

Thanks in advance!

P.S. An answer in russian is welcome :)