Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what are db_options used for?
- 1 Answers
- 9471 Views
- InterGraph, I also Faced
- E-Mail Answers
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)
