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

How to use old values to define new values in update statements in ms sql server?

673

---

Do you know the isolation level that sql server support?

522

---

Can a database be shrunk to 0 bytes, if not, why?

636

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

493

---

Mention the uses of stored procedures.

564

---

---

Do you know what are different types of replication in sql server?

504

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

647

---

What is sql or structured query language?

671

---

How do I find the transaction log size in sql server?

509

---

How do I open a .db file?

476

---

What is transaction server implicit?

525

---

What are the instances when triggers are appropriate?

518

---

What is stretch database in sql server?

559

---

How to create a store procedure with encryption?

517

---

How to use “drop” keyword in sql server and give an example?

678

---