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 difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

Do you know what is lock escalation?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

What are the diifferences between the ms sql server vs mysql?

0 Answers  

---

What are sql servers used for?

0 Answers  

---

What is normalization and its types?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

---