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 are commonly used odbc functions in php?

1009

---

Can you leave a union at any time?

1052

---

How do I create a trace in sql server?

1023

---

what is the system function to get the current user's user id? : Sql server database administration

1003

---

Explain about remote stored procedure?

997

---

What are cursors and when they are useful?

1077

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1017

---

What are character string data types in ms sql server?

1230

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

948

---

What is the difference between primary key and unique constraints?

947

---

Explain different types of lock modes in sql server 2000?

926

---

What is data source in connection string?

898

---

How to assign new column names in a view?

909

---

What is sql profiler. What are the default templates with it? : sql server database administration

1022

---

Define right outer join in sql server joins?

1032

---