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?

Please let us know if you are still having this problem. We are looking into a solutionfor this error. Thanks.

Greg Landwehr
Moderator

Yes I have the Same problem existing even now.

But I don't which one is causing the problem. When this exception comes entire server get hung up and we need to restart the problem. Its very big head ache for to reboot the sql server often.

Thanks in advance
Babu

Babu