Answer Posted / tap_ks

SQl Profiler is a tool provided by SQL Server, which can
capture the queries, procedures executed on the database.
It also capture all the details like user, m/c, input
parameters, time of execution etc. This is very helpful
while bebugging any query / procedure.

Tell me about builtinadministrator?

1046

---

What are the basic features of a trigger in ms sql server?

1269

---

Explain datetime2 data type in sal server 2008?

953

---

What is the purpose of forms?

1004

---

Where do you find the default Index fill factor and how to change it?

1118

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

960

---

How do I know if localdb is running?

1001

---

What is the maximum rows in sql server table?

964

---

Can I save my report as html, excel or word? : sql server management studio

1013

---

What are the ways available in sql server to execute sql statements?

1208

---

What are the 2 types of classifications of constraints in the sql server?

1184

---

What is a self join in sql server?

1195

---

What are data regions?

140

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1050

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125

---