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 are the types of subquery?

0 Answers  

---

Do you know what are acid properties?

0 Answers  

---

explain query execution plan

1 Answers  

---

Explain what are sparse columns?

0 Answers  

---

Can you explain full-text query in sql server?

0 Answers  

---

What is trace flag in sql server?

0 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

How to rebuild master databse?

0 Answers  

---

How do I get to sql server configuration manager?

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---