I'm reading Professional SQL Server 2000 Programming (Rob Viera).
There is example how to create FOREIGN KEY that references column in the same table (page 196). If I run code:

ALTER TABLE Employees
ADD CONSTRAINT FK_EmployeeHasManager
FOREIGN KEY (ManagerEmpID) REFERENCES Employees (EmployeeID)

I would get error:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

I'm running Win2K server, with 'Microsoft SQL Server 2000 - 8.00.384 (Intel X86) May 23 2001 00:02:52 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: )'
Any ideas what is wrong?

The code you've attempted to run looks fine.

Build 760 is the latest build for SQL Server 2k, I believe. Looks like you are a service pack behind.

Can you create the FK constraint via the database diagram? Click the manager column and drag back onto the table itself and see if that works. You might also try a server restart.



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks Jeff,
I'll download latest Service Pack, and try it again. It works fine when I create constraints referencing other table. The problem only when constraint references the same table

I once saw similar errors on a server. A stick of RAM had gone. If you still get the problems after applying the service pack you might want to check your hardware platform.

regards
David Cameron