[dba-SQLServer] SPs are read-only

what options do you have for the ODBC passthrough query?... i'm a bit foggy
on these details but I think you need to have them set to dynamic snapshot.

if you're using an ADP, then you need to refernce the updateable table in
the form's property.

On 1/25/06, John Colby <jwcolby at colbyconsulting.com> 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?
>
> TIA,
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...