Answer Posted / rathi

SQL profiler is a graphical tool that allows system
administrator to monitor in an instance of the SQL Server.

Use of SQL Profiler:
• Monitor the performance of an instance of SQL
Server.
• Debug Transact-SQL statements and stored procedures.
• Identify slow-executing queries.
• Test SQL statements and stored procedures in the
development phase of a project by single-stepping through
statements to confirm that the code works as expected.
• Troubleshoot problems in SQL Server by capturing
events on a production system and replaying them on a test
system. This is useful for testing or debugging purposes
and allows users to continue using the production system
without interference.
• Audit and review activity that occurred on an
instance of SQL Server. This allows a security
administrator to review any of the auditing events
including the success and failure of a login attempt and
the success and failure of permissions in accessing
statements and objects.

How can you find out how many rows returned in a cursor?

969

---

What is the difference between grant and with grant while giving permissions to the user?

898

---

Explain nested trigger in sql?

1005

---

Explain “not null constraint” in sql server?

956

---

What are the different editions available in sql server 2000?

993

---

What does null mean?

938

---

What are logical/boolean operations in ms sql server?

978

---

How is table type constraint applied to a table?

933

---

What will be query used to get the list of triggers in a database?

954

---

what are acid properties? : Sql server database administration

928

---

How to transfer a table from one schema to another?

938

---

Why use “pivot” in sql server?

1042

---

What command do we use to rename a db, a table and a column?

873

---

What kind of problems occurs if we do not implement proper locking strategy?

1356

---

How to delete database objects with "drop" statements in ms sql server?

1033

---