How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answers were Sorted based on User's Feedback
Answer / m.sivakumar
The SQLSERVR.EXE is located in binn directory of Sql server.
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / hanumathkumar
-m is used for starting SQL Server in single user mode.
-f is used to start the SQL Server in minimal configuration
mode.
| Is This Answer Correct ? | 2 Yes | 2 No |
Explain optimistic and pessimistic concurrency?
What options are available to audit login activity? : sql server security
What is postgresql server?
What is named query? : sql server analysis services, ssas
Explain what is “asynchronous” communication in sql server service broker?
How to handle errors in Stored Procedures.
What are the recovery models in sql server 2000?
What is row_number () and partition by in sql server?
What is database black box testing?
How to find the last update record in SQL Server?
In the primary key have a multiple field or not?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
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)