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

What stored by the master? : sql server database administration

1184

---

What is a derived table?

994

---

What is sql server agent and what are the two modes of authentication in sql server?

1112

---

What do you understand by physical_only option in dbcc checkdb?

1026

---

Do you know clustered and non-clustered index?

1025

---

How to connect a database with sql express.?

1120

---

Which is better statement or preparedstatement?

984

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

1009

---

What part does database design plays a role in performance of an sql server-based application?

1036

---

How to drop an existing table?

1054

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

can any body tell me how to know the password of current user in sql server

2120

---

Explain what is scheduled job and how to create it?

1026

---

What is the difference between migration and upgradation in sql server?

1138

---

Explain primary key in sql server?

1075

---