x

Can't Find Stored Procedure

I'm pretty new to this. I have a report in Visual Studio running off a Stored Procedure I need to manipulate it in SQL Server Management Studio. I didn't write any of this, I'm trying to repair it. I need to make some changes to the Stored Procedure, but can't find it anywhere, and it appears there are others that are missing too. Is there a way to find the path to the stored procedure from the report in Visual Studio? I've tried everything I can think of and I still can't find it. Any help would be greatly appreciated. Gee
more ▼

asked Sep 01 '12 at 01:07 AM in Default

Gee gravatar image

Gee
10 2 2 2

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Right click on your datasource to see the properties. There you can find the connection string to your data source. Connect to this database using SSMS to find your stored procedure. Please notice: Datasets can also base on plain SQL code, that means your data can be retrieved form tables, views or even functions - not only stored procedures. So examine your dataset first.
more ▼

answered Sep 01 '12 at 11:07 AM

eghetto gravatar image

eghetto
2.1k 15 17 21

Im sorry, could you explain that a little more in detail? I can see the connection string to the report, but not to the stored procedure.
Sep 01 '12 at 05:14 PM Gee
I recommend you to use Microsoft's Report Builder (2.0 for SQL 2005 or 3.0 for SQL Server 2008 R2). This is a light weight tool compared to Visual Studio. Using Report Builder you can easily connect to your SSRS-Server and see all datasources which your report incorporates: http://www.microsoft.com/de-de/download/details.aspx?id=6116
Sep 05 '12 at 04:50 PM eghetto
(comments are locked)
10|1200 characters needed characters left

If you have the report open in Visual Studio you can simply look at the data table for the report (.rdl file). It will show you the exact code being executed for that specific report. (See image below for example). As already mentioned you can check your data source properties for the database the procedure is being executed from.

If you need more than this let us know...

alt text

capture.jpg (48.3 kB)
more ▼

answered Sep 05 '12 at 05:35 PM

Shawn_Melton gravatar image

Shawn_Melton
5.3k 17 21 29

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x534
x401

asked: Sep 01 '12 at 01:07 AM

Seen: 1538 times

Last Updated: Sep 05 '12 at 05:37 PM