No results from query in some contexts

From: Iain (Iain_at_idclTAKEAWAY.co.uk)
Date: 11/24/05 

Date: Thu, 24 Nov 2005 12:58:11 +0000

I have a database with a number of tables in and some stored procedures to
read from them

WHen I expect the sprocs from within VS2005 (or my asp.net application) I
get no results returned, even though opening the table in VS 2005 shows teh
data I expect.

Running the same sproc from SQL Server Management studio returns the
expected results.

The data was inserted in the tables (in at least one case) from teh asp.net
application that cannot now read it!

I sort of think this could be a security / role related problem, but I
really can't see what!

Does this ring any bells?

Iain 

-- 
Iain Downs (DirectShow MVP)
Commercial Software Therapist
www.idcl.co.uk

Relevant Pages

  • RE: view vs sproc
    ... i contest. ... Sprocs are for wen you need paramaters although ... Users of SQL server often dont ... In many other databases views are a better choice over using stored procedures for ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Stored Procedures with a Grid View
    ... my gridview and formview controls in a current project. ... I found that for the delete and update sprocs I had to specify the primary ... > I'm trying to use Stored Procedures with a Grid View and everytime I try ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: view vs sproc
    ... Sprocs are for wen you need paramaters although ... Users of SQL server often dont ... In many other databases views are a better choice over using stored procedures for ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to: Can you build a Typed DataSet for a stored procedure w/o using a DataAdapter?
    ... > If you want to create a DataSet, you can drag tables from Server explorer ... > into it, but not stored procedures. ... > sprocs instead of tables? ... and it creates the typed dataset with the results the stored procedure ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: parallelism
    ... the Query Optimizer to decide; there is no change you can to your sprocs to ... > We are running our SQL Server on a computer with eight CPUs. ... > We would like some of our larger stored procedures to be run in parallel ...
    (microsoft.public.sqlserver.programming)