Unable to access views and stored procedures from asp

Tech-Archive recommends: Fix windows errors by optimizing your registry

hai all,

This is manju, I am not able to execute views and stored procedures
but able to excute tables. Back end is SQL SERVER. I am accesing
database tables , views and stored procedures from ASP.

Error while executing views and stored procedures

Error: Object not found.

All the tables , views and stored procedures have same user name and
are created using query analyser. All have access permissions.


Thaks
Manju
kanna_manju2000@xxxxxxxxx

.

Relevant Pages

  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: parallelism
    ... SQL Server can not execute multiple stored procedures at ...
    (microsoft.public.sqlserver.programming)
  • Re: Extended stored procedures failues - only under sql server log
    ... I'm talking about "home grown" extended stored procedures. ... For example, 'sa' can execute xp_cmdshell, but CANNOT execute our ... regardless of the fact that its sql server login is ...
    (microsoft.public.sqlserver.programming)
  • Re: Invalid stored procedures are getting created which have errors
    ... one method to validate procs is to execute with ... is to actually execute it. ... > i'm having a strange issue with SQL server 2000. ... > create stored procedures that have critical erros. ...
    (microsoft.public.sqlserver.server)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)