In SQL server 2000, in a trigger When i use the Exec(), it cannot find the deleted table. Why?
EXECUTE (‘Insert into TestTable Select PatientID from Deleted’)