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 |
What are the two types of concurrency?
How do you start single user mode in clustered installations?
Explain the disadvantages/limitation of the cursor?
What is difference between equi join and inner join?
Mention the differences between having and where clause.
I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output
What is a select query statement in ms sql server?
What is difference between stored procedure and function?
Explain what is analysis service repository?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What does it mean to manipulate data?
What is triggers and stored procedures?
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)