Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what are db_options used for?
- 1 Answers
- 9594 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 is 1nf 2nf?
How do I debug a stored procedure in sql server?
How to link up the text file to a Database table?
How to create an identity column?
How to select some specific columns from a table in a query in ms sql server?
What is update locks?
How to provide values to user defined function parameters?
How does a profiler work?
What are secondary xml indexes?
What is table-valued sub query?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
can primery key be a non clustered index?
-
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)
