Answer Posted / muruganandam05

In this The Administrators can use to access a running
server even if the server is locked or othervise
unavailable .This capability enables administrators to
troubleshoot problems on a server by executing diagnostic
function or Transact-SQL-Statements.

What is #temp and @table variable in SQL server?

587

---

what are the important architecture components of SSRS?

94

---

How to perform key word search in tables?

536

---

How can I add Reporting Services reports to my application?

91

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

551

---

---

What is a document index?

590

---

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

552

---

What is the purpose of optimization?

546

---

Tell me can we use custom code in ssrs?

601

---

Distinguish between nested subquery and correlated subquery?

552

---

What are exact numeric data types in ms sql server?

514

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

532

---

What is table join?

602

---

What is named calculation? : sql server analysis services, ssas

535

---

How do I make a resultset scrollable?

517

---