Answer Posted / 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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is database replication? What are the different types of replication you can set up in sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is 'write-ahead log' in sql server 2000 ?
What are approximate numeric data types in ms sql server?
What is the usage of the sign function?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain data warehousing in sql server?
How to delete multiple rows with one delete statement in ms sql server?
Tell me what is normalization? Explain different forms of normalization?
Explain about remote stored procedure?
How to delete existing rows in a table?
How many cores do I need for sql server 2016?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
how will add additional conditions in sql?
Describe the functionalities that views support.
