Answer Posted / ravi raj chelluri

Displays or changes database options, and enables the
asynchronous log service feature.

Syntax
sp_dboption [dbname, optname, optvalue [, dockpt]]


Examples:

1) Displays a list of the database options

sp_dboption


2)Allows select into, bcp and parallel sort operations on
tables in the advanturewors database

use Advantureworks
go
master..sp_dboption Advantureworks, "select into", true
go

Why are views required in the sql server or in any other database?

907

---

How to write a query with a right outer join in ms sql server?

870

---

What is a partition function in sql server?

1023

---

What is the difference between the 2 operating modes of database mirroring?

1056

---

what is the maximum size of a row? : Sql server database administration

940

---

How we can compare two database data?

873

---

Do you know what is normalization of database? What are its benefits?

1028

---

How will you add a dimension to cube? : sql server analysis services, ssas

1012

---

Write an SQL query to obtain the 2nd highest salary.

1019

---

What do you understand by hotfixes and patches in sql server?

914

---

What is standby servers? Explain types of standby servers.

930

---

what is blocking? : Sql server database administration

980

---

Explain different types of Normalization.

1734

---

What is a rollup clause?

908

---

What is query optimizer in sql server?

957

---