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

Explain differentiate between a having clause and a where clause?

0 Answers  

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

What do you understand by recursive stored procedure?

0 Answers  

---

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What is the use of RDBMS?

0 Answers   Wipro,

---

How can I know what locks are running on which resource?

0 Answers  

---

What is a partition key?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

What does it mean to manipulate data?

0 Answers  

---