Re: Question on Database Project

This means that either you're initial catalog is pointing to the wrong
database, you don't have rights to access the SPs or you created the SPs in
the wrong database.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

<nashak@xxxxxxxxxxx> wrote in message
news:1128179395.538307.35370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
>
> I'm working on a asp.net project under VS-2003. I have created a
> database project and connected to my database and created some stored
> procedures. When I run my app, I get the error - "Stored procedure not
> found".
>
> I'm sure I'm missing some step to either compile this SP or do
> something so that my code recognises the SP.
>
> Could someone point me to the right direction or provide step by step
> details on how to create a DB project and how to create SP in VSTudio
> and go from there?
>
> Thanks,
>


.

Relevant Pages

  • Re: Does nesting stored procedures make sense to increase performa
    ... I like the idea of calling individual SPs from one because it gives me the ... modifications in the stored procedure, this only affects that single SP. ... "sloan" wrote: ... I know that database calls are ...
    (microsoft.public.sqlserver.programming)
  • Re: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)