Re: DELETE permission denied problem when using a stored proc to delet

From: Jens (Jens_at_sqlserver2005.de)
Date: 10/12/05


Date: 12 Oct 2005 00:25:04 -0700

As long as you dont activate ownership chain (as I assume that you are
deleting data in a different database) this won´t work. Ownerchip
chains is disabled by default since SP3.

Look for cross database ownership chain in BOL or for the thread:

http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/4b86a2ccefd974af

HTH, JEns Suessmeyer.