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

What is an expensive query?

931

---

What is table-valued sub query?

968

---

Is it true, that there is no difference between a rule and a check constraint?

1057

---

Tell me the difference between clustered and non-clustered index?

937

---

How does a profiler work?

932

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

---

List the different index configurations possible for a table?

934

---

How many types of triggers are there?

1064

---

What are points to remember while using the fillfactor argument?

970

---

Explain mixed authentication mode of sql server?

1064

---

What is sql server profiler?

1005

---

Which command is used for user defined error messages?

1060

---

What is the difference between local and global temporary tables?

1138

---

What are sparse columns?

1013

---

What are different replication agents and what's their purpose? : sql server replication

1019

---