Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what are db_options used for?
- 1 Answers
- 9499 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 |
explain declarative management framework (dmf) in sql server 2008?
Can you name some of the dml commands in sql?
What are the characteristics of modern DBMS?
Explain database normalization?
Write an SQL query to obtain the 2nd highest salary.
0 Answers Akamai Technologies,
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
How to enforce security in sql server? : sql server security
What is The Use Of TIMESTAMP DataType in SQL Server 2005?
How you can change a cross join into an inner join?
Explain what is analysis service repository?
What is a trigger in sql server?
What are the differences between substr and charindex in 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)
