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
How to create “dependant” parameter “make, model, year”
Can sql servers link to other servers like oracle?
Can we add a cpu to sql server?
What is replace and stuff function in sql server?
Difference between Sql server reporting services and Crystal reports?
How to add a new dsn with the odbc driver for sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
where the connection string store in the database
how would you troubleshoot blocking? : Sql server database administration
In how many ways you can invoke ssrs reports?
What are the dis_advantages of stored procedures, triggers, indexes?
What are magic tables in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
Why do we need normalization?
What are the advantages of using third-party tools?
