Explain what are db_options used for?
Answer / 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 |
Why would you use sql agent?
Whether the updations made to the views reflect the original records in the table
When columns are added to existing tables, what do they initially contain?
How to provide column names in insert statements in ms sql server?
Tell me what is fill factor?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are truncate options available in sql server? : sql server database administration
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
can you any body tell me which service pack is installed in the sql server?
What are the differences between local and global temporary tables?
Why we need a group by clause?
What is forward - only cursors / read only cursor?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)