How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?

Answer Posted / abc

sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about builtinadministrator?

588


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

530


What is the correct order of the logical query processing phases?

521


What are the properties of the transactions?

612


What is clustered index

567






What is the difference between a local and a global temporary table?

618


What are different types of statement?

523


what are constraints? : Sql server database administration

517


How to delete existing triggers using "drop trigger"?

556


What does it mean to normalize data?

512


What is data modification?

507


What is store procedure? When do you use?

523


Explain about thread and memory management process of SQL?

532


What is indexing in sql server with example?

521


What is an expression in ms sql server?

566