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 use of @@ spid in sql server?

0 Answers  

---

What is sql injection? How to protect against sql injection attack?

0 Answers  

---

Explain an incremental backup?

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What information is maintained within the msdb database?

0 Answers  

---

Explain in brief about Microsoft SQL server?

0 Answers  

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

Why functions are used in sql server?

0 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---