Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 Posted / guest

Answers were Sorted based on User's Feedback



Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not ac..

Answer / kumar

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 ?    3 Yes 0 No

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not ac..

Answer / guest

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 ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do I view a stored procedure in sql server?

0 Answers  

Do you know what are the restrictions that views have to follow?

0 Answers  

List out different types of normalizations in sql server and explain each of them?

0 Answers  

Explain forward - only cursors?

0 Answers  

What is an Index?

3 Answers   Yardi Software,

Can you explain full-text query in sql server?

0 Answers  

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

what is difference between having and where clause ?

3 Answers  

Explain multiserver query

0 Answers  

Tell me about Triggers?

3 Answers   Cap Gemini,

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories