"Mary Chipman [MSFT]" wrote:

> Sorry for the late response, I hope you already solved it, but if not,
> here we go. There were a few things that need to be configured
> properly to get debugging in SQL 2000 to work from VS. I searched on
> "VS.NET debug stored procedures" and came up with quite a few hits.
> This one looks like it might help:
> http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/
>
> However, if it's a VS 2005 problem you may need to do another search.
>
> --Mary
>
> On Fri, 12 May 2006 10:40:02 -0700, garibaldi
> <garibaldi@nospam.nospam> wrote:
>
> >Yes, I did create a database project. Sorry, I should have been more specific.
> >
> >"Mary Chipman [MSFT]" wrote:
> >
> >> Did you create a database project? If not, that's what you need to do.
> >>
> >> --Mary
> >>
> >> On Fri, 12 May 2006 08:54:01 -0700, garibaldi
> >> <garibaldi@nospam.nospam> wrote:
> >>
> >> >Sorry if this question has been asked before.
> >> >
> >> >VS2005 and MSSQL 2000. I can get a project created and read the MSSQL2K
> >> >database tables. However, I can't retrieve the stored procedures and open
> >> >them in the IDE, i.e. modify.
> >> >
> >> >Am I trying to do the impossible? If not then what may I be missing?
> >> >
> >> >Thanks in advance.
> >>