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 |
Is the primary key column of a table an index in ms sql server?
Explain what is the purpose of sql profiler in sql server?
How to write character string constants or literals in ms sql server?
why would you call update statistics? : Sql server database administration
How many instances per computer are there in sql server 2000?
How can you find out which stored procedures are recompiling?
Explain the steps to use transact-sql cursor?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is a coalesce function?
What is Inner Join?
Explain Active/Active and Active/Passive cluster configurations
how to determine the service pack currently installed on sql server? : Sql server database administration