Although this is a client side issue (VB.NET) I was wondering if anyone
could help.
I'm iterating through the stored procedures for the names but its missing
some out and duplicating or triplicating others. The count of sprocs is
correct, does this mean that a sql system table is incorrect.
Any ideas?
Thanks
FrankIs it possible that there are mustiple copies of the SP created under
different users? This can happen is someone logs into the DB as a user
without DBO rights, and creates a SP without specifying the DBO prefix as
part of the SP name.
For example, if Frank logs into the DB and creates a SP like this:
CREATE PROCEDURE usp_order_insert
Then there could be 2 different versions of the SP:
DB.frank.usp_order_insert
DB.dbo.usp_order_insert
"Frank Ashley" <a@.a.com> wrote in message
news:%23OSCFYUYFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Although this is a client side issue (VB.NET) I was wondering if anyone
> could help.
> I'm iterating through the stored procedures for the names but its missing
> some out and duplicating or triplicating others. The count of sprocs is
> correct, does this mean that a sql system table is incorrect.
> Any ideas?
> Thanks
> Frank
>|||Thats what I thought at first and in fact the offending sproc was indeed
missing dbo. Even though I fixed this error though it's still not showing
up.
Frank
"JT" <someone@.microsoft.com> wrote in message
news:%23XuiiuVYFHA.3488@.tk2msftngp13.phx.gbl...
> Is it possible that there are mustiple copies of the SP created under
> different users? This can happen is someone logs into the DB as a user
> without DBO rights, and creates a SP without specifying the DBO prefix as
> part of the SP name.
> For example, if Frank logs into the DB and creates a SP like this:
> CREATE PROCEDURE usp_order_insert
> Then there could be 2 different versions of the SP:
> DB.frank.usp_order_insert
> DB.dbo.usp_order_insert
> "Frank Ashley" <a@.a.com> wrote in message
> news:%23OSCFYUYFHA.3620@.TK2MSFTNGP09.phx.gbl...
>|||Did you login as SA or DBO and delete the SPs?
"Frank Ashley" <a@.a.com> wrote in message
news:udq2QhWYFHA.584@.TK2MSFTNGP15.phx.gbl...
> Thats what I thought at first and in fact the offending sproc was indeed
> missing dbo. Even though I fixed this error though it's still not showing
> up.
>
> Frank
> "JT" <someone@.microsoft.com> wrote in message
> news:%23XuiiuVYFHA.3488@.tk2msftngp13.phx.gbl...
as
missing
>|||Yep. Tried that.
"JT" <someone@.microsoft.com> wrote in message
news:%23BudU3WYFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Did you login as SA or DBO and delete the SPs?
> "Frank Ashley" <a@.a.com> wrote in message
> news:udq2QhWYFHA.584@.TK2MSFTNGP15.phx.gbl...
> as
> missing
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment