.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

BIDS 2005 cannot find Stored Procedure

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
I have read how to do this in multiple places but my report is not able to use a stored procedure for retrieving data. When I select command type 'stored procedure' to populate my dataset, and then switch to the GUI query designer, I only see a partial list of system SPs, not my user defined SPs. My SP does return a single dataset.If I try to manually use the SP, with or without doublequotes and EXEC, the report designer simply tells me that the SP cannot be found.

View Complete Post

More Related Resource Links

DTA doesn't find referenced table form stored procedure with SP_executesql

Using the SQL2008R2 profiler and DTA connected to a SQL2000 server. I created a tuning tracefile with profiler for a certain db on the sql2000 server because I need to tune 1 table in the database referenced by 3 parameterized stored procedures which built a query depending on the parameters and is executed with an sp_executesql statement. When I run the DTA loading the tracefile I see the exec stored procedure events with it's parameters and the message Event does not reference any tables. And that's it. The DTA generates no Recommendatioin at all. How can I get the exact sql statements in the tracefile so the DTA can do what he needs to do? Regards

Could not find stored procedure 'sys.sp_MScreate_tempgenhistorytable'.

I'm getting the following error when initializing a merge replication subscription: Source:  Microsoft SQL Native Client Number:  2812 Message: Could not find stored procedure 'sys.sp_MScreate_tempgenhistorytable'. Both publisher and subscriber are version 9.0.4053 Scripted the missing proc from publisher and ran create proc (using sa credentials) on subscriber but I get an error message: Msg 2760, Level 16, State 1, Procedure sp_MScreate_tempgenhistorytable, Line 45 The specified schema name "sys" either does not exist or you do not have permission to use it. Kind of stuck right now, any help would be appreciated. Thanks, Patrick

SQL Server 2005 - Specifying Optional Parameter in Stored Procedure

I need to alter the following stored procedure so that the UserID is an optional parameter. I have, as yet, been unsuccessful. Basically, if the user doesn't supply a User ID, I want to return all of the users that match the other criteria.

This seems like it should be a simple thing.......


@CompanyID tinyint

,@DepartmentID tinyint

,@ApplicationID int

,@UserID AS









FROM [ReportQueries]


[UserID] = @UserID

With Recompile and Execute as clause in SQL 2005 Stored Procedure



I am working on an asp.net application which uses quite a few sql 2005 procedures. Due to some change in requirement I had to modify a couple of the procedures.

During this change, I found that most of the procedures contain clause With Recompile, Execute As Caller.

I am planning to refactor the code in procedure but not sure if I can remove these clauses. Can any one please help me with these?

Thanks in advance.

how to create stored procedure in sql server 2005 and how to use that stored procedure in asp.net


Hi friends ,

       I am very newbie

I have created stored procedure and student database and also asp.net application for asp.net page

but it could not found stored procedure what is the mistake actually I don't no

Please help me

Warm Regards


could not find the stored procedure dbo.pro_logchange



when I adding the content database to webapplication in sharepoint 2010 I got this error

could not find the stored procedure dbo.pro_logchange.

any idea ?

Think More..Do More..

MSSQL 2005 JDBC driver multiple select statements in stored procedure



we have a stored procedure with multiple select in it.



Select a,b,c from table1

Select f,g,h  from table2

Select j,k,l  from table3


Sometimes select no 2 will not return any values.

when this happens  we get only 2 result sets using CallableStatement getMoreResults method. 

it seems that if a select  doesn't return something it will  not have a corresponding resultset. 

On 2000 (driver + server) version we got an empty resultset for this situation. 

Is there  any  way to have the same behaivor with 2005 ?   We tryed with 1.2 and 2.0 jdbc driver.




sp_addpublication throwing Could not find stored procedure


I ran in to a strange problem yesterday that I still haven't resolved. I moved a replicated database from a SQL 2000 server to a 2008 server using backup/restore and when doing the restore I used the restore wizard (didn't have my script library available) and I checked the "preserve replication setting" (WITH KEEP_REPLICATION) checkbox without the distributor being configured first. This was obviously a mistake on my part and nothing worked as I had hoped. I then removed all replication related stuff using the "Disable distribution and publishing"-wizard and everything was removed, including the publications that came with the old database that I restored. As far as I know I was back to a cleen slate.

Then I configured the distributor again without a hitch but when I tried to create the publication I got a weird error. I had scripted the creation of the publication and when running the exec sp_addpublication I got the following error:

Msg 2812, Level 16, State 62, Procedure sp_MSrepl_addpublication, Line 1357
Could not find stored procedure ''.


Has anyone seen this before...? I've searched both this site and googled but can't seem to find anything. The database is not mirrored and the database is SQL 2008 SP1 Standard.


Lumbago www.thefirstsql.com

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.


 Dear all ASP.NET Members

Iam using Visual Studio 2010 ultimate

Iam trying to use a CreateUserWizard control, but iam getting this error below,eachtime i click the click user. Kindly guide me where iam getting wrong.this has disturbed me for two dayz,figuring out where the problem is but i cannot see it.kindly help.

Kindly see Both my web.config file below and the type of error iam getting.

This is my web.config file below


xml version

CRUD Stored Procedure Code/Scripts Generator for SQL SERVER 2005


I need a simple anf functionally CRUD Stored Procedure Code/Scripts Generator.

Anyone have a solution?

Thanks in Advance.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.


I kept getting this using ASP.NET Administration Tool/Security tab:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Any suggestion is much appreciated.

Selecting Oracle Stored Procedure in SSRS Crashes Visual Studio 2005 IDE


Problem Conditions

I have a very simple Oracle (11g) Stored Procedure that is declared like so:

* FROM MyTable;

This compiles correctly. The cursor contains col1, col2 and col3.

In SSRS, i have a Shared Data Source that uses Oracle OLEDB Provider for Oracle 11g:


Cannot find execute any query, stored procedure not found even if it is there


Hey guys,

I am getting frustrated with this problem, I dont know what i did, but now I cannot execute any stored procedured when I could last time.

When I use my asp.net application to run the query, it finds the stored procedure but when I execute it is sql management studio it says it cannot find the stored procedure even though it is there.

I tried to execute other procedures and the samething happens. Even when I try a simple query it says it cannot find the table

I could execute the query if i placed Use [databasename] in front, but even with this, I cannot execute stored procedures.

does any1 know how to fix this?

Ju Lian

Is this possible to do in a MSSQL 2005 stored procedure?


I'm fairly new to MSSQL and I need help designing a stored procedure.  What I want to do is create a stored procedure with three parameters, startDateTime, endDateTime, and interval; that generates a count for the number of rows in my table.  Here is some sample data in the data_time column that I want to use for grouping:

2010-11-02 07:56:34.083
2010-11-02 07:56:34.617
2010-11-02 08:21:05.567
2010-11-02 08:21:05.997
2010-11-02 08:33:04.080

Here is what I want the stored procedure to return (when the interval param is set to 10 this would be in minutes)

dateTime                                  cnt

2010-11-02 07:56:34.083         123

2010-11-02 08:06:34.083           37

2010-11-02 08:16:34.083         145

Is this something that can be done in a stored proced or does my application need to do the grouping?

Here is my table definition:

 CREATE TABLE [dbo].[wsaxis2_rlog](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [date_time] [datetime] NULL,

SQL Server 2005 Grant User Permission to Create Stored Procedure and Grant Execute Access to another


I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.

We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.

Grant Create Stored Procedure to user1 on a specific database

Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.


Error 2812 Could not find Stored procedure


I am running sql server 2005 standard edition with sp3.

I get this error when my scheduled jobs are running:

NT AUTHORITY\SYSTEM. Could not find stored procedure (Error 2812). The step failed

How do I resolve it.



Need Urgent Help on this 'Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.



Server Error in '/staff' Application.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend