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
Tell me what is difference between view and materialized view?
Do you know what are the reporting services components?
What is stretch database in sql server?
How many clustered indexes there can be on table ?
What is sql server profiler trace data file?
What is open database communication (odbc)?
What is the downside of using udf?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Why functions are used in sql server?
What is tablesample?
How do we Backup SQL Azure Data?
What is implicit cursors?
What is a transact-sql statement?
When you should use a low fill factor?
How do I start sql server agent automatically?