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.

Explain differentiate between a having clause and a where clause?

915

---

How to generate create procedure script on an existing stored procedure?

1014

---

What are different types of data sources?

1023

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

946

---

How check triggers in sql server?

998

---

How to generate random numbers with the rand() function in ms sql server?

1160

---

Do you know what is lock escalation?

1015

---

Explain unique key in sql server?

1013

---

What are the dmvs? : sql server database administration

1067

---

What are the general features of sql server management studio? : sql server management studio

1087

---

Do you know what are the restrictions that views have to follow?

1081

---

How to define and use table alias names in ms sql server?

1138

---

When cursors are useful?

1115

---

What is transaction server implicit?

1015

---

Explain the properties of subqueries in sql server?

1084

---