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

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

What is pessimistic concurrency?

0 Answers  

---

How do I find the sql server version?

0 Answers  

---

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---