Answer / 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

What happens when transaction log is full?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

How to connect php with different port numbers?

0 Answers  

---

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What does the automatic recovery do?

0 Answers  

---

What is sleeping status in sql server?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---