Could not find stored procedure error

I'm having the oddest issue. I can execute a select query on a database but
I get an error when I try to execute a stored procedure. It is probably
something dumb but I have tried everything I can think of. I'm not having
much luck searching the web either.

I have been using SqlCommand and SqlDataAdapter objects to retrieve a
DataTable. I swear, there is nothing obviously wrong with my usage. I have
been working this way for a while. There is something about that one
database which is preventing it from finding my stored procedures.

Has anyone ever run across this?

Thanks,
Len Switzer,
ITOutfitters

Yes by instance as I by accident rename or delete a SP

Cor

"x86asm" <x86asm@discussions.microsoft.com> schreef in bericht
news:98B7C79E-1AFF-4340-99DD-4955B0CABBAB@microsoft.com...
> I'm having the oddest issue. I can execute a select query on a database
> but
> I get an error when I try to execute a stored procedure. It is probably
> something dumb but I have tried everything I can think of. I'm not having
> much luck searching the web either.
>
> I have been using SqlCommand and SqlDataAdapter objects to retrieve a
> DataTable. I swear, there is nothing obviously wrong with my usage. I
> have
> been working this way for a while. There is something about that one
> database which is preventing it from finding my stored procedures.
>
> Has anyone ever run across this?
>
> Thanks,
> Len Switzer,
> ITOutfitters
>

Yes, I guess that would do it.

I wish that were the case. This issue only occurs on my dev box, not on the
deployment server. It also only occurs with SQL 2005 on my dev box, SQL 2000
does not show the issue. It has something to do with SQL 2005 on my dev
box....

I wish I was more expert with SQL setup and settings.

"Cor Ligthert[MVP]" wrote:

> Yes by instance as I by accident rename or delete a SP
>
> Cor
>
> "x86asm" <x86asm@discussions.microsoft.com> schreef in bericht
> news:98B7C79E-1AFF-4340-99DD-4955B0CABBAB@microsoft.com...
> > I'm having the oddest issue. I can execute a select query on a database
> > but
> > I get an error when I try to execute a stored procedure. It is probably
> > something dumb but I have tried everything I can think of. I'm not having
> > much luck searching the web either.
> >
> > I have been using SqlCommand and SqlDataAdapter objects to retrieve a
> > DataTable. I swear, there is nothing obviously wrong with my usage. I
> > have
> > been working this way for a while. There is something about that one
> > database which is preventing it from finding my stored procedures.
> >
> > Has anyone ever run across this?
> >
> > Thanks,
> > Len Switzer,
> > ITOutfitters
> >
>