Any way to use files from separate directories in mgmt studio?

Is there any way to add files from 2 different directories and have them retain their directory identity within the solution? When I attempt to add a file from another directory, mgmt studio makes a copy of the file in the default directory for the solution, which is not what I want. I want to be able to edit the script and have it stay (and update) within the directory from which it came. The only way I see now is to have multiple solutions, but since mgmt studio appears to only allow me to have one solution open at a time, this doesn't work either. Any suggestions?How are you performing this change, DTS or script?

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 keyboard shortcut for "open table" in Mgt Studio?

Folks, does anyone know if there is a keyboard shortcut to open a database table in Management Studio? I refer to the equivalent to right-clicking on a table to choose "open table", in order to view/edit the data.

I find no reference to an equivalent in the menu, nor even any reference to "open table" in the online help. I've dug around the web, to no avail. Surely other keyboard fans must groan at the need to touch the mouse for this frequent operation. Thanks in advance.

Windows functionality:

SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
ALT+underlined letter in menu: Opens the menu

|||Might refer to the keyboard shortcuts on using SSMS ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/fb4edf3c-71b6-4645-b1d1-ddfdd69f0d7b.htm link. Why do you need to open the table in SSMS which is slow if the table has too many rows or volume based. In thsi case using Query Analyzer is best one to go to view the data.|||Thanks very much. I'm a big keyboard fan, but that's one I'd just missed (or not had reason to notice it before). That does solve the problem for me.|||

Thanks, but that's about creating new shortcuts. I was looking for any existing ones. The previous answer about using shift-f10 will suffice.

As for why one would use the "open table" option, do you realize that it permits editing the data? That's certainly much easier in that interface than using SQL statements in query analyzer. Sure, you're right that if you had a large table it may not make sense. I don't, so it works fine for me.

Any hierarchical functionatility in Management Studio in 2005

I am thinking, if there is the functionality that can hierachically group the tables, views, and stored procedures into different sections within each database, it will be much clearer and logical for maintain the database objects.

For example, to create containers in the console tree of Management Studio or Enterprise Manager, or even apply the namespace/subnamespace features to the tables/views/stored procedures of each database.

A clearer explanation:

Inside each database, all the tables, stored procedure and views are at the same level, if new folders/containers can be created to segmen all these database objects into different groups, it will be much more clear.

An even advanced feature is to apply namespace concept to the database objects, so that it will truly hierachical besides the appearnce in the console tree.

|||

This probably isn't exactly what you're looking for, but ...

You can use SCHEMAs to put tables, procedures, types, etc. into separate namespaces.

From SSMS, you can

Create a new schema from the "Database/Security/Schemas" node in Object Explorer|||

This functionality does not currently exist. You can submit this suggestion through https://connect.microsoft.com/SQLServer.

Cheers,

Dan

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 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.