any way to debug stored procedures without buying visual studio?

Hi.

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.

Can someone suggest a free or lower cost alternative?

sorry to be so cheap.. its the times I think.Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.
>
Can someone suggest a free or lower cost alternative?
>
sorry to be so cheap.. its the times I think.

PRINT and SELECT is what I use, even in SQL 2000. I used to use the
T-SQL debugger occasionally, but I gave up on it. There were so many stars
that had to be aligned for it to work.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 2, 3:18 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Jeff Kish (kishjj...@.charter.net) writes:

Quote:

Originally Posted by

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.

>

Quote:

Originally Posted by

Can someone suggest a free or lower cost alternative?

>

Quote:

Originally Posted by

sorry to be so cheap.. its the times I think.

>
PRINT and SELECT is what I use, even in SQL 2000. I used to use the
T-SQL debugger occasionally, but I gave up on it. There were so many stars
that had to be aligned for it to work.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

~
T-Sql debugger is some what okay, I used very long back.
I'm very comfortable with Print and Select commands to debug a stored
procedure.

~NR|||On Fri, 2 Feb 2007 10:18:24 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.sewrote:

Quote:

Originally Posted by

>Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

>I am under the understanding that having the sql server 2005 db is not
>enough (like 2000 was) to debug stored procedures.. that I need to
>purchase (costly) visual studio 2005.
>>
>Can someone suggest a free or lower cost alternative?
>>
>sorry to be so cheap.. its the times I think.

>
>PRINT and SELECT is what I use, even in SQL 2000. I used to use the
>T-SQL debugger occasionally, but I gave up on it. There were so many stars
>that had to be aligned for it to work.

Thanks. I'll give it a try.
The debugger had been fairly nice to use when I had triggers and sp's
to debug.

I assume that it is a simple matter to invoke the procedure (I know
how to compile it) to get things to run?

Regards,
Jeff|||Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

The debugger had been fairly nice to use when I had triggers and sp's
to debug.
>
I assume that it is a simple matter to invoke the procedure (I know
how to compile it) to get things to run?

Not sure that I understand the question, just run it from Query Analyzer.

Triggers are a good point for the debugger. If you are not aware of that
there is a trigger, the debugger can make you aware, if you stick to F11.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Any Help please!

Hi there
I am new to asp.net so I am not sure what I am doing wrong??
I have installed Visual Studio 2003, and the .net framework, we currently use sql server 2000
I have created a report in visual studion with raw SQL and I want to deploy it to my local host, however I get the message "no report server was found at (my server)"
I also tried to install reporting services but when I do I get the message "asp.net not registered with web server"
I know I am proberly missing something simple but I just cant locate it
Any help appreciated
Thanks
TimHi

catalystcommercial

You can't install SQL Reporting Services on a non server OS. You can only install a client version on XP to allow you to create SRS reports and preview them. When you build your SRS projects in VS 2003 it tries to deploy the report to your actual reportserver(server OS box). In your case you didn't specify a location. Do this : In VS2003. Click on Project >> Properties >> Configuration Properties >> Delpoyment. Fill in the "TargetServerURL" something likehttp:\\<server>\reportserver and add a TargetFolder to deploy the report to. Just click OK and build the Solution it will deploy the report to your SQL Reporting Server box.

, Hope this helps

l0n3i200n

|||

Hi

Thanks for the reply, I tried what you said and I still get the message "no report server was found at....."

PS: I am running this on our local server with server 2000

Regards

Tim

|||

There is a necessary sequence of events to follow:

Let me try to understand what you have posted -

Windows 2000 or 2003 was installed as the OS -

After installation did you go to MANAGE YOUR Server and indicate that within MANAGE YOUR SERVER ROLES the following:

Application Server indicate to configure Front Page Extensions and ASP.Net

After that you installed SQL 2000

Installed the service packs especially SP3a

Downloaded RSEVAL (Reporting Services)

Installed with SP1 and SP2

After reporting services was installed - go to IIS and select properties of Report Server and make sure anonymous access is disabled.

From your browserHTTP://localhost/reports

If you cannot get to the above http - then there are a bunch of minor issues - post back!

If you can get to above URL

edit administrator and ensure they can dio everything for the time being

Within your RS project point to your server and also to your database within the project properties and also ensure this is the dame within your data sources (shared) or spperate.

Data Source=YOUR SERVER NAME;Initial Catalog=YOUR DATA BASE NAME

Post back so we can help!

|||I read this post again - Run RSGEGISTER -- Done deal --|||

I am having the same problem. My SQL Server is on my machine. But the Report Server is on a server that I have to access, not on my machine. I keep getting the error:

---

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpCannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection)Get Online HelpAn OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.

Any good books on Microsoft Reporting Services for a Visual Studio developer?

I'm starting to useMicrosoft Reporting Services and coming from a Crystal background. I'm wondering if anyone is aware of a good book that addresses development of Microsoft reports within the Visual Studio context.

Thanks!

BCB

I just ordered Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson through amazon this morning. It is supposed to be here tomorrow sometime. I can let you know if it is any good. It did get good reviews on the amazon site and I also found amazon to be the cheapest.

I am having problems with my reporting deployment to the server. It keeps telling me that the ASPNET account does not have sufficient privileges to perform the operation.

|||I have been using Brian Larson's book (SQL Server 2005 Reporting Services) for several months and it is wonderful. It reminds me of a good Wrox book in the sense that it uses cumulative examples where a report that was developed earlier may be used as the basis for demonstrating a new feature. (Don't get me wrong - there are a bunch of report types in the book including Web Services.) You can work through the examples yourself or there is downloadable source code. The book covers both the design and administration side of Reporting Services. The book is less than 600 pages (not counting the appendices) and it has many screen shots that make explicit what the author has just described in words. I like that. The examples really work and files that he references are present in the folders where he states they will be found. I like that even more. Larson isn't just a technical guy who knows a lot about this product; he's an accomplished writer as well. I found that the book was a fairly quick read that managed to leave a lot of knowledge behind after I put it down for the final time. Did I mention that I recommend it?|||Hey guyin kalamazoo,

I just recently went through this learning curve. You have to add permissions for ASPNET to the database that the datasource is trying to access. Unless you store the credentials in the datasource, then it will use those credentials to access the database.

Anyway, look into the permissions for ASPNET on the machine with the database, and make sure you have the proper roles setup on the reporting server.

I hope this helps, as I am still relatively new to SSRS2005.

Anthony

Any easy way to create SQL on the fly with RS?

I am very new to reporting services. I am using reporting services
with Visual Web Developer and my database is Oracle 10g.
I have successfully created reports using the MS reporting services.
Data were pulled out from Oracle 10g through pre-defined SQL.
I would like to display on the web a list of fields that my end users
can select, and then my web application creates the SQL command on the
fly according to end users' selection criteria. Any easy way to do
this with the reporting services?
I hope that I have made clear what effect I would like to achieve. If
not, please ask. Thanks.If you are using SSRS 2005 then you got the answer. Just have a look at what
is called "Report Model" where in you can create a view where you can give
the readable column names and the users can drag and drop to get the reports.
Amarnath
"antonyliu2002@.yahoo.com" wrote:
> I am very new to reporting services. I am using reporting services
> with Visual Web Developer and my database is Oracle 10g.
> I have successfully created reports using the MS reporting services.
> Data were pulled out from Oracle 10g through pre-defined SQL.
> I would like to display on the web a list of fields that my end users
> can select, and then my web application creates the SQL command on the
> fly according to end users' selection criteria. Any easy way to do
> this with the reporting services?
> I hope that I have made clear what effect I would like to achieve. If
> not, please ask. Thanks.
>|||Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
> "antonyliu2002@.yahoo.com" wrote:
> > I am very new to reporting services. I am using reporting services
> > with Visual Web Developer and my database is Oracle 10g.
> >
> > I have successfully created reports using the MS reporting services.
> > Data were pulled out from Oracle 10g through pre-defined SQL.
> >
> > I would like to display on the web a list of fields that my end users
> > can select, and then my web application creates the SQL command on the
> > fly according to end users' selection criteria. Any easy way to do
> > this with the reporting services?
> >
> > I hope that I have made clear what effect I would like to achieve. If
> > not, please ask. Thanks.
> >
That sounds great. I am not sure which version I am using, but I just
downloaded it a few weeks ago from Microsoft as a plug-in for Visual
Web Developer. I'll check it out.|||> Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
>
Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
2005. I was not able to see anything called "Report Model" in VWD.
As I mentioned before, I've successfully created reports using this
Add-in. But the reports I created were predefined. I would like to
let my web users select what data they would like to get from the
database, and then create the SQL on the fly. I hope that I can do
this with this Reporting Add-in.
Any idea about how I can do this? Thanks.|||antonyliu2002@.yahoo.com wrote:
> > Amarnath wrote:
> > If you are using SSRS 2005 then you got the answer. Just have a look at what
> > is called "Report Model" where in you can create a view where you can give
> > the readable column names and the users can drag and drop to get the reports.
> >
> > Amarnath
> >
> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
> 2005. I was not able to see anything called "Report Model" in VWD.
> As I mentioned before, I've successfully created reports using this
> Add-in. But the reports I created were predefined. I would like to
> let my web users select what data they would like to get from the
> database, and then create the SQL on the fly. I hope that I can do
> this with this Reporting Add-in.
> Any idea about how I can do this? Thanks.
I've googled a little bit, and the tutorials I found on creating
reporting models all use BI Development Studio. Does this mean that I
cannot possibly create a reporting model with the Add-in in Visual Web
Developer 2005?|||The BI tools come with their own version of VS. If you have it, it
integrates with it. If not, then it installs it. This means that VS 2005
does not need to be purchased.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161640436.894263.5660@.i3g2000cwc.googlegroups.com...
> antonyliu2002@.yahoo.com wrote:
>> > Amarnath wrote:
>> > If you are using SSRS 2005 then you got the answer. Just have a look at
>> > what
>> > is called "Report Model" where in you can create a view where you can
>> > give
>> > the readable column names and the users can drag and drop to get the
>> > reports.
>> >
>> > Amarnath
>> >
>> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
>> 2005. I was not able to see anything called "Report Model" in VWD.
>> As I mentioned before, I've successfully created reports using this
>> Add-in. But the reports I created were predefined. I would like to
>> let my web users select what data they would like to get from the
>> database, and then create the SQL on the fly. I hope that I can do
>> this with this Reporting Add-in.
>> Any idea about how I can do this? Thanks.
> I've googled a little bit, and the tutorials I found on creating
> reporting models all use BI Development Studio. Does this mean that I
> cannot possibly create a reporting model with the Add-in in Visual Web
> Developer 2005?
>|||> Bruce L-C [MVP] wrote:
> The BI tools come with their own version of VS. If you have it, it
> integrates with it. If not, then it installs it. This means that VS 2005
> does not need to be purchased.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
Thanks, Bruce, are you suggesting that the BI Development Studio is
free? Where can I get it?
I have no Visual Studio 2005, what I have is the free Visual Web
Developer 2005.|||It is free. It comes on the SQL Server media.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161658217.724868.128170@.b28g2000cwb.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> The BI tools come with their own version of VS. If you have it, it
>> integrates with it. If not, then it installs it. This means that VS 2005
>> does not need to be purchased.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
> Thanks, Bruce, are you suggesting that the BI Development Studio is
> free? Where can I get it?
> I have no Visual Studio 2005, what I have is the free Visual Web
> Developer 2005.
>|||> Bruce L-C [MVP] wrote:
> It is free. It comes on the SQL Server media.
>
Thanks, Bruce.
Before I proceed, I have a question. We don't use MS SQL Server as our
database behind our web application. Instead, we use Oracle 10g. Will
I be able to create a web-based application that allows users to create
ad-hoc reports using the SQL Server reporting services and Oracle 10g?
Thanks.|||Developers yes, end users no.
Report Designer is for developers and that works against Oracle. For end
users there is a another tool where first a developer/dba creates a model
and that model is used by the end users to create their own reports. Models
can not be created against Oracle data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161703326.930679.107880@.i3g2000cwc.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> It is free. It comes on the SQL Server media.
> Thanks, Bruce.
> Before I proceed, I have a question. We don't use MS SQL Server as our
> database behind our web application. Instead, we use Oracle 10g. Will
> I be able to create a web-based application that allows users to create
> ad-hoc reports using the SQL Server reporting services and Oracle 10g?
> Thanks.
>|||> Bruce L-C [MVP] wrote:
> Developers yes, end users no.
> Report Designer is for developers and that works against Oracle. For end
> users there is a another tool where first a developer/dba creates a model
> and that model is used by the end users to create their own reports. Models
> can not be created against Oracle data.
>
Thanks, Bruce.
I am new to Reporting Services. The kind of reports I've managed to
create with the Reporting Services Add-in in Visual Web Developer are
from predefined SQL queries.
Just for the purpose of simplicity, suppose that in my web application,
I present the names of 10 students in a dropdown list. I would like to
let my web users select one of these students and then I construct the
sql query on the fly, and create a report about this selected student
only.
Is this do-able with the Reporting Services Add-in in Visual Web
Developer 2005 Express Edition?
Thanks.

Any debugger in MSSQL 2005?

In SQL Server 2005, is there any debugging tools for T-SQL programming works similar to that in Visual Studio .NET?You have to use visual Studio to debug TSQL in SQL 2005. There is nothing in management studio.