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
What is the meaning of sql server?
What is raid? : SQL Server Architecture
What are the differences between having and where clause.
Define tempdb database?
What is table level trigger?
how to take backup bcp out for a column in table in sql server?
Explain how many types of relationship?
Why use “pivot” in sql server?
What is a non-clustered index?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Why variables called the most powerful component of ssis?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is difference between order by and group by?
What is public role in sql server?
What is create command?