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

Define clusters?

1008

---

what is blocking? : Sql server database administration

985

---

How to name query output columns in ms sql server?

924

---

What is raiseerror? What is raiseerror?

1081

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

954

---

Explain about system database?

1012

---

Explain the concepts and capabilities of sql server?

929

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

963

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

---

What are the advantages of having an index on the sql server?

879

---

How exceptions can be handled in sql server programming?

960

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

119

---

State the difference between union and union all?

895

---

What is lookup override?

976

---

Can you force a query to use a specific index?

894

---