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 are exact numeric data types in ms sql server?
How can I check if a view exists in a sql server database?
What are cursors in ms sql server?
What is a covering index?
What is the Difference Between Primary and Foreign Key?
What is table constraint?
What action plan is preferred if sql server is not responding?
What are approximate numeric data types in ms sql server?
How do I find the sql server instance name?
What are the advantages of user-defined functions over stored procedures in sql server?
Explain ranking functions?
How to see the event list of an existing trigger using sys.trigger_events?
How can delete duplicate records in cte in sql server?
How to use old values to define new values in update statements in ms sql server?
What are the different types of Indexes available in SQL Server?
