ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to restart SQL Server in single user mode? How to start 
SQL Server in minimal configuration mode?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Answer
# 1		 
SQL Server can be started from command line, using the 
SQLSERVR.EXE. This EXE has some very important parameters 
with which a DBA should be familiar with. -m is used for 
starting SQL Server in single user mode and -f is used to 
start the SQL Server in minimal confuguration mode. Check 
out SQL Server books online for more parameters and their 
explanations.
 
Is This Answer Correct ?    0 Yes 0 No
Swapna
 
  Re: How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Answer
# 2		 
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 0 No
Abc
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is a view? is View updatable? IBM10
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan? HCL2
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.  1
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
What is the datatype returned by count(*) Asian-CERC16
What are Sql Reporting Services and analysis services? Can u Explain  1
one table has four field id,name,design,salary. i have to find maximum salary .  6
How to create logins using windows Authentication mode?  1
write the query for find the top 2 highest salary in sql server TCS17
Alternative way to DetDate() function?  2
Explain some DBCC commands?  3
What is normalization in Database ?  3
What are explicit and implicit transactions?  1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
What is the system function to get the current user's user id? HCL1
how insert selected column only ? Robert-Half1
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?  6
How do you measure the performance of a stored procedure? Infosys1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com