BI Dev Studio Licensing

I have a client that we're hosting a website for and we have a few reports
that we've done for them. They're wanting to create and publish their own
reports now and I'm wondering what to buy. They picked up Visual Studio Standard
Edition because on the MSDN site it says Standard does Reporting Services,
but after installing it, there's no Reporting Services Project type. I tried
having them install the client tools for SQL 2005 but the installer said
Reporting Services tools were already installed, not making much sense. How
exactly do I get them the BI Development Studio and does that require another
SQL 2005 license?SQL Server 2005 is licensed by the Server. There is no license for the
development tools. Unlike RS 2000, it ships with a version of VS if it is
not installed. If you have VS 2005 installed then it will install into that.
It doesn't make sense that it says the tools are already installed. I have
VS 2005 (because I needed VB.Net) and then installed VS 2005 BI on top of
that. VS 2005 has controls for Reporting Services IF you are creating your
own website or windows app. If all you want to do is create reports what you
want to do is install the BI client tools found on the SQL Server 2005 CD.
They can uninstall VS and any BI tools they find and then try again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Josh Belden" <joshuabelden@.hotmail.com> wrote in message
news:dee73200137b98c7f6131ce52f7c@.news.microsoft.com...
>I have a client that we're hosting a website for and we have a few reports
>that we've done for them. They're wanting to create and publish their own
>reports now and I'm wondering what to buy. They picked up Visual Studio
>Standard Edition because on the MSDN site it says Standard does Reporting
>Services, but after installing it, there's no Reporting Services Project
>type. I tried having them install the client tools for SQL 2005 but the
>installer said Reporting Services tools were already installed, not making
>much sense. How exactly do I get them the BI Development Studio and does
>that require another SQL 2005 license?
>

Best way to do a free text search

HiI have a .net 2 website that works from a sql 2000 db. I am building a form that will allow the user to type in any search criteria and based on their input I need to produce some results (that's the simplest way to put it)I will need to search various parts of my db to find similar sounding information, I was just wondering what is the best way to do this. I had the following thoughts1) Search columns using Soundex tsql function (but not sure how good this is?)2) Remove all noise words from user input (eg, and, or, the etc...) and then use a regular expression to search the fields in the dbAlternatively are their some third party components to do can do this for me Many thanks in advance

You can full text search enable the database, and create a full text index on the column in the table you want to search. Then you will be able to search any word that appears inside that column. Here are a couple of links that might be helpful to you.

http://www.databasejournal.com/features/mssql/article.php/3441981

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

http://msdn2.microsoft.com/en-us/library/ms177652.aspx

|||

Hi

Thanks for that, it was a great help

I have noticed that their is a RowNumber method in SQL 2005, is their any way to do this functionality in SQL 2000

One method I thought of was to put the data in temp table and loop through each record and give it a number, and then pull out 10 records at a time as the user pages through.

Are their any other ways I could do this.

Many thanks in advance

|||

The short answer is yes. You may want to search for articles on Custom Paging with SQL Server 2000. There are ways to do it, but they are not as simple or clean as the ROW_NUMBER() function. Here is an article to get you started.

http://www.4guysfromrolla.com/webtech/042606-1.shtml