[AccessD] Stored Procedure return value

Francisco Tapia fhtapia at gmail.com
Thu Jan 29 16:17:27 CST 2009


ah ... ok
-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Thu, Jan 29, 2009 at 2:09 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I am not on the SQL list, and have no intention of ever
> again being on the SQL list.
>
> Thanks for the reply though.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> Francisco Tapia wrote:
> > replied on sql list...
> > -Francisco
> > http://sqlthis.blogspot.com | Tsql and More...
> >
> >
> > On Thu, Jan 29, 2009 at 1:49 PM, jwcolby <jwcolby at colbyconsulting.com
> >wrote:
> >
> >> I see nothing there about debugging stored procedures.  I
> >> Googled and found that IF you happen to own the advanced
> >> versions of VS you could use them to do debugging.
> >> Unfortunately I only own the standard edition.
> >>
> >> According to what I read, the debugging was migrated out to
> >> VS in 2005, and the standard edition of VS would NOT do it.
> >>
> >> John W. Colby
> >> www.ColbyConsulting.com
> >>
> >>
> >> Francisco Tapia wrote:
> >>> Debugging of stored procedures is available in Sql Server 2000 and Sql
> >>> Server 2005, in fact it's quite robust.
> >>> -Francisco
> >>> http://sqlthis.blogspot.com | Tsql and More...
> >>>
> >>>
> >>> On Thu, Jan 29, 2009 at 6:58 AM, jwcolby <jwcolby at colbyconsulting.com>
> >> wrote
> >>> <SNIP>
> >>>
> >>>> <Rant Mode>
> >>>>
> >>>> My problem in all of this is that I very much a novice at
> >>>> SQL Server.  I have been forced to dig in but, like Access,
> >>>> there is just so much to know.  If I sit here just
> >>>> "experimenting" trying this and that I get nowhere.  There
> >>>> is no "debugger" for SPs so it is "try something, run and
> >>>> see".  Worse yet the totality of the feedback is "error near
> >>>> XXX in line YYY", not exactly stellar help.
> >>>>
> >>> </SNIP>
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list