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

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What are approximate numeric data types in ms sql server?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

---

What is recompile sql server?

0 Answers  

---

on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

What is buffer cash and log cache in sql server?

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---

What are constraints in microsoft sql server?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---