Answer Posted / bruhaspathy medishetty

Report Server is not a tool when you compare it with Report
Manager or Report Builder.

Report Server can be defined as the Server which has SQL
Server Reporting Services Installed. All the reports are
generated and processed before rendering on this Server.

Report Manager is the one tool which is used by SSRS
Admin/Developer to manage the reports, Data Sources, Roles
and Schedules etc. There is a Browser based Report Manager
apart from the one available from the Management Studio.

Report Builder is again a browser based tool that enables
in creation of adhoc reports by end users without really
knowing much about the underlying Database Details.

See SQL Server Books Online for more.

Thanks,
Bruhaspathy
www.learnsqlwithbru.com

Do you know the policy based administration feature of sql server 2008?

908

---

What do you understand by intent locks?

956

---

How to populate a table in sql server?

894

---

last function used in MS Access to convert sql what function will use in sql

2019

---

Write the syntax for stuff function in an sql server?

979

---

Explain about SQLOS?

948

---

Name few of the dcl commands in sql?

952

---

How do I install only the client tools of sql server 2000?

995

---

What is table-valued sub query?

924

---

whats new about truncate in sql server 2008?

2442

---

What are the encryption mechanisms in sql server?

970

---

How can sql server instances be hidden? : sql server security

1055

---

What is extended stored procedures?

902

---

Write a sql query to sort on different column name according to the parameters passed in the function?

855

---

What is a field in a table?

985

---