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  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
Answer
# 1		 
In such cases we can first bring to db to single user using
sp_dboptions and then we can rename that db and then we can
rerun the sp_dboptions command to remove the single user mode.
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
Answer
# 2		 
In This case you take following action

1. Alter DataBase <dbname> set single_user with rollback 
immediate

2. Sp_renamedb 'olddb','newdb'

3. Alter DataBase <dbname> set multi_user

 By
Kumar.T
 
Is This Answer Correct ?    0 Yes 0 No
Kumar
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro21
What is the difference between HAVING clause and the WHERE clause?  4
what is meant by deafult in sql server?  2
how to dispaly a particular row details from a given table  1
What is a job?  3
What is the appropriate number of test cases that you can write on a database? Microsoft1
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  14
how to get 25th row in any table in sqlserver can u tell me syntax  4
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?  4
How do you fine the performance tunning? Accenture2
Can you link only other SQL Servers or any database servers such as Oracle?  1
Advantages and Disadvantages of Cursor? Zenith4
What are the different types of joins and what does each do?  2
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?  3
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they. IBM5
what is the order of execution of where,having,group by in select stement Tanla-Solutions4
what is physical sort data and logical sort data in index?  1
What is ACID Property of Transaction?  3
explain different types of jions with examples briefly? Zensar2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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