Answer Posted / punithalakshmi

sp_help is the correct answer.

How does a profiler work?

906

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1029

---

What is fill factor and pad index?

995

---

What is entity data services?

1036

---

What are the different kinds of ssrs reports?

212

---

What is the use of set nocount on/off statement?

1074

---

What is sharding?

116

---

What extended events?

988

---

What are sp_configure commands and set commands?

998

---

What do you understand by intent locks?

990

---

What is the web service used for reporting services?

123

---

what are isolation levels? : Sql server database administration

966

---

What are exact numeric data types in ms sql server?

1049

---

What is the default order of an order by clause?

971

---

How to convert character strings into numeric values?

1077

---