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 |
What are statistics?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Diffrences between sql server 2000 vs 2008
How to select all columns of all rows from a table with a select statement in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Differentiate between SQL and ORACLE joins and write their syntax.
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How to verify a login name with sqlcmd tool?
Define full outer join?
Do you know the cursor optimization tips?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are the types of sql server?
Oracle (3259)
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)