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 indexing explain it with an example?
Can we perform backup restore operation on tempdb?
what is the primary use of the model database? : Sql server administration
What is the contrast between sql and pl/sql?
Why truncate is ddl command?
What are sub reports and how to create them?
How to enable/disable indexes?
What is a coalesce function?
How many columns can we include on clustered index ?
What happens if date-only values are provided as date and time literals?
How can sql server instances be hidden?
Is there any difference between primary key and unique with the not null condition?
What is ddl and dml commands?
Differentiate between ms sql server reporting services vs crystal reports?
What are some examples of schemas?
