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
Which is the main third-party tool used in sql server?
What are the properties of the transactions?
What language is sql server written in?
What do you understand by intent locks?
Explain intellisense for query editing
Describe and explain about SQL native client?
What is the maximum length of an alert name?
What are data resources?
Explain what is dbcc?
What are the character string functions supported by sql server 2005?
Explain go command in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How to trouble shoot if unable to connect SQL Server
Do you have any idea about the tcl commands?
