How to Re-Install Reporting Services in SQL 2005?

I have removed Reporting Service from SQL2005.
Now, I want to install it again.
The setup does not give me this option.
What should I do to re-install reporting services again?
Thank youOn Mar 5, 12:41 pm, "leoh" <leonardomach...@.gmail.com> wrote:
> I have removed Reporting Service from SQL2005.
> Now, I want to install it again.
> The setup does not give me this option.
> What should I do to re-install reporting services again?
> Thank you
It sounds kind of like you were not able to completely uninstall SSRS.
I believe that there is a Microsoft utility that should be able to
remove the remanants of the original SSRS; however, I don't remember
the name of it. Sorry, I wish I could help you further.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to register SQLExpress 2005 from SQL Server Management Studio?

I noticed SQL2005 XE installation does not come with SQL Server
Management Studio. If I install SQL2005 XE on a machine, how can I
connect to it thru SQL Server Management Studio from my workstation?
In sql2k, you can register a SQL MSDE thru EM, is there a change to
this in sql2k5? I went thru the readme file for sql2005 xe but there's
no mention of this topic.
I do not want to use SSMSE mentioned in this article to manage the
sql2005 xe, I want to use the regular SQL Server Management Studio to
manage it.
<http://support.microsoft.com/kb/907716>
Thank you"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1132274300.199134.140290@.g44g2000cwa.googlegroups.com...
>
> I noticed SQL2005 XE installation does not come with SQL Server
> Management Studio. If I install SQL2005 XE on a machine, how can I
> connect to it thru SQL Server Management Studio from my workstation?
> In sql2k, you can register a SQL MSDE thru EM, is there a change to
> this in sql2k5? I went thru the readme file for sql2005 xe but there's
> no mention of this topic.
> I do not want to use SSMSE mentioned in this article to manage the
> sql2005 xe, I want to use the regular SQL Server Management Studio to
> manage it.
> <http://support.microsoft.com/kb/907716>
>
Register it just like any named instance. However by default TCP/IP, Named
Pipes and the Browser service are disabled in Express Edition installs.
Enable them to connect to the named instance from a remote machine.
David|||hmm...that's what i thought. however i was unable to register the XE.
(i understand TCP/IP was disabled by default).
can the machine have hyphen in it? such as 'my-test-machine'?

How to query for master-detail output on same page

I'd like to create a master-detail output from SQL2005 to display in a page using classic ASP. Ideally, I want the output to contain a <div> to show/hide the order details beneathe the order header, as shown below.

OrderNo OrderDate

1001 7/27/2007

+ <div to show/hide>

Item Description

AAA desc_for_itemAAA

BBB desc_for_itemBBB

+ </div>

1002 7/26/2007

+ <div to show/hide>

Item Description

CCC desc_for_itemCCC

+ </div>

I currently just have a stored procedure returning the results and it is very slow as I'm simply querying the details section for each order header. Does anyone have any ideas on how I can create an efficient and fast method for returning these results in the format above?

It’s always better to do these rendering on the ASP/UI page,

For your courtesy,

Code Snippet

Create Table #order (

[OrderNo] int ,

[OrderDate] datetime

);

Insert Into #order Values('1001','7/27/2007');

Insert Into #order Values('1002','7/26/2007');

Create Table #orderdetails (

[OrderNo] int ,

[Item] Varchar(100) ,

[Description] Varchar(100)

);

Insert Into #orderdetails Values('1001','AAA','desc_for_itemAAA');

Insert Into #orderdetails Values('1001','BBB','desc_for_itemBBB');

Insert Into #orderdetails Values('1002','CCC','desc_for_itemCCC');

Select

OrderNo,

OrderDate,

Replace(Replace((Select '<td>' + Item + '</td><td>' + Description + '</td>' as [text()] From #orderdetails OD Where OD.[OrderNo] = O.[OrderNo] For XML Path('tr')),'&gt;','>'),'&lt;','<')

From

#order O

<!--

On ASP/UI page,

While NOT rs.eof

Response.Write(“<tr><td>”)

Response.Write(rs(0))

Response.Write(“</td><td>”)

Response.Write(rs(1))

Response.Write(“</td></tr><tr>”)

Response.Write(“<td colspan=2><span style='cursor:hand' click=ExpandOrCollopse(‘div_” + rs(0) + “’)>+</span>”)

Response.Write (“<div style='display:none' id=’div_”)

Response.Write(rs(0))

Response.Write(“’><table>”)

Response.Write(rs(2))

Response.Write(“</table></div>”)

Wend

-->

|||

What you are proposing is clearly a presentation side issue and should not be 'forced' on SQL Server.

I suggest that you may find utility in the new XML output functionality.

|||

Manivannan, thanks for the sample code. I was able to create an output as you explained.

Arnie, can you point me to an easy to understand resource for this xml output functionality? I haven't really had any exposure to xml.

|||

Here are a couple of resources to get you started:

http://www.topxml.com/sql/

http://technet.microsoft.com/en-us/library/ms175024.aspx

Using XML data is perfect for web applications.