How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
- 3 Answers
- 10359 Views
- HCL, I also Faced
- E-Mail Answers
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
Explain the rules for designing files and file groups in sql server?
How to connect to a sql server using odbc_connect()?
What information is maintained within the msdb database?
What is shared lock?
What is service broker?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Define tempdb database?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Write a sql query to sort on different column name according to the parameters passed in the function?
Explain what is the use of custom fields in report?
What is recompile sql server?
How to get all stored procedures in sql server?
Explain different types of lock modes in sql server 2000?
What is sql server transaction log file?
What is difference between index and primary key?
