Answer / 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 execute the cursor queries with "open" statements?

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

Define normalisation?

0 Answers  

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

How to execute function in stored procedure sql server?

0 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

Explain error and transaction handling in sql server?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Why use stored procedures in sql server?

0 Answers  

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

What is Lock table in SQL?

0 Answers   Wipro,

---