[dba-SQLServer] SPs are read-only

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jan 26 02:06:37 CST 2006


On 26 Jan 2006 at 2:27, John Colby wrote:

> Is there a magic incantation to make my SP editable?  My tables are
> read/write but a simple SP that pulls the same data (filtered on a couple of
> ID fields) is read-only.  Any thoughts on why this is?
> 

Make sure that  your recordset include the primary from every referenced 
table.





-- 
Stuart





More information about the dba-SQLServer mailing list