Answer Posted / hanumathkumar

-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.

What are the filtered indexes?

1029

---

Explain datetime2 data type in sal server 2008?

898

---

How to list all triggers in the database with sys.triggers in ms sql server?

1061

---

Explain transaction isolation levels in sql server?

1100

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

923

---

How to search for a string in all stored procedure in sql server?

983

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1034

---

What is the importance of three tier architecture?

1079

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1027

---

What is implicit cursors?

1072

---

Difference between report and query parameter.

1078

---

How is a full-text index updated?

944

---

What is a result set object returned by odbc_exec()?

1010

---

What is the synonym of join?

950

---

How to use wildcard characters in like operations in ms sql server?

1123

---