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 |
mention different types of relationships in the dbms?
How to check if a table is being used in sql server?
Mention the differences between local and global temporary tables.
What is the name of the system variable that returns the number of rows affected by a SQL statement?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is the default server name for sql server?
How can you stop stored procedures from recompiling?
How to Install SQL SERVER 2005 remotely?
Do you know how to implement service broker?
What happens if null values are involved in string operations?
How many types of Joins in SQL Server 2005?
9 Answers CarrizalSoft Technologies, HCL,
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)