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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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 
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 ?    1 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 Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?  2
Explain different isolation levels?  3
what is difference between nchar and char in Sql server ?  2
What is referential integrity? What are the advantages of it? Digital-Domain3
What is BCP? When do we use it?  1
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
what are file groups? Evalueserve3
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions1
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?  1
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution? Aptech4
What types of integrity are enforced by a foreign-key constraint  1
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
What is de-normalization and when do you do it?  3
What is the STUFF function and how does it differ from the REPLACE function?  2
What is The Use Of TIMESTAMP DataType in SQL Server 2005?  3
How can I know what query is executing by by a particural user? (using sp id or any othe way.)  2
can you any body tell me the how to decrease the logfile  4
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
What is Covering Indexes? Plz explain with example  2
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM4
 
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