Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How to truncate the log in sql server 2012? : sql server database administration
How to concatenate two strings in SQL Server.
What are indexers?
What is the difference between ddl,dml and dcl commands?
What is the process of normalising?
What is the stuff and how does it differ from the replace function?
what data regions are and what are the different data regions?
can an automatic recovery be initiated by a user? : Sql server administration
What is the difference between implicit and explicit transaction?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is exporting utility?
What do you mean by stored techniques? How would we use it?
What does asynchronous call backs means?
