I got this error when running this:
CREATE TRIGGER del_cache_content
ON content
FOR DELETE
AS
DELETE FROM cache WHERE cid = deleted.cid;
GO
The column prefix 'deleted' does not match with a table name or alias name
used in the query.
Why is that? deleted is a system (conceptual) table yah...
