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

mention different types of relationships in the dbms?

0 Answers  

---

How to check if a table is being used in sql server?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

What is the default server name for sql server?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

Do you know how to implement service broker?

0 Answers  

---

What happens if null values are involved in string operations?

0 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---