1. What are the two authentication modes in SQL Server?

There are two authentication modes –

  • Windows Mode
  • Mixed Mode

Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page.

2.  What Is SQL Profiler?

SQL Profiler is a tool which allows system administrator to monitor events in the SQL server.  This is mainly used to capture and save data about each event of a file or a table for analysis.

3. What is recursive stored procedure?

SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively. It can nest up to 32 levels.