Answer Posted / senthil ku,mar

Use sp_configure to display or change server-level
settings. To change database-level settings, use ALTER
DATABASE. To change settings that affect only the current
user session, use the SET statement

How to find the version of sql server? : sql server database administration

1044

---

Explain few of the new features of sql server 2008 management studio

858

---

How many triggers you can have on a table?

933

---

What do you understand by a stored procedure?

1038

---

Explain indexes disadvantages?

1009

---

How to create an identity column?

1135

---

How do I find the sql server database version?

939

---

Explain timestamp datatype?

907

---

Explain about protocol layer present in SQL server?

1101

---

How will you know when statistics on a table are obsolete?

1029

---

Does sql server 2000 full-text search support clustering?

813

---

What is local temp table?

891

---

How to update values in a table with update statements in ms sql server?

956

---

What is multi-statement table-value user-defined function?

932

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1031

---