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 is bcp? When does it used?

983

---

How we can compare two database data?

953

---

How to loop through the result set with @@fetch_status?

1354

---

What do you understand by physical_only option in dbcc checkdb?

981

---

If we delete pack Spec what will be the status of pack Body ?

1478

---

What is open database communication (odbc)?

1069

---

Is the log file is a part of file group?

1041

---

what is an extended stored procedure? : Sql server database administration

1063

---

Why truncate is ddl?

1095

---

How to execute a sql statement using mssql_query()?

1056

---

What is inline table-value user-defined function?

1117

---

How do I make a resultset scrollable?

966

---

Which are the new data types introduced in sql server 2008?

887

---

Do you know how to store and query spatial data?

1043

---

Why use view instead of a table?

956

---