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

Can we join two tables without primary key?

1042

---

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

986

---

what purpose does the model database serve? : Sql server database administration

968

---

What do you mean by authentication modes in sql server?

1080

---

What are the authentication modes in sql server? How can it be changed?

1120

---

How can I track the changes or identify the latest insert-update-delete from a table?

948

---

Does full backup break log chain?

958

---

How to use go command in "sqlcmd"?

1197

---

What is the default schema of your login session in ms sql server?

1045

---

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

974

---

Does a full backup include transaction log?

961

---

What do you mean by cardinality?

901

---

how would you troubleshoot blocking? : Sql server database administration

977

---

What do we need queues in sql service broker?

1065

---

What is inline table-value user-defined function?

1105

---