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 is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Can we store videos inside the sql server table?

0 Answers  

---

What is an expression in ms sql server?

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

How do indexes help, types?

0 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---