Answer Posted / pradeep

Sqlprofiler is a tool to debug, troubleshoot,monitor and measure your applications and sqlstatements and stored procedures.The tool enables you to select which events you want to monitor .......

How to list all login names on the ms sql server?

1079

---

What is logon trigger?

1028

---

What is instead of dml trigger?

951

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

985

---

How to optimize stored procedure optimization?

843

---

What are the differences between triggers and stored procedures?

990

---

What is difference between delete & truncate commands?

1023

---

Do you know what is rank function?

1029

---

How we can compare two database data?

873

---

What is SQL Azure Federations?

112

---

How you can get the list of largest tables in a database?

943

---

Describe the left outer join & right outer join. : sql server database administration

957

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1694

---

What is the difference between push and pull subscription? : sql server replication

1149

---

How to disable stored procedure sql server?

1525

---