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 |
Explain system views?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
What is auditing in sql server?
What is the command used to get the version of sql server?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are logical database components? : SQL Server Architecture
Explain log shipping and mention its advantages.
Where do we use trace frag?
How to write query to Delete the records in child table and corresponding records in parent table
How to round a numeric value to a specific precision?
what is a mixed extent? : Sql server administration
Is SET a SQL Keyword?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)