Click here to Skip to main content
12,697,783 members (26,210 online)
Rate this:
 
Please Sign up or sign in to vote.
hi am new to sqlserver 2008 unfortunately i clicked detach in tasks of database with project tables developed by some body..... after clicking this detach in tasks of database that is not appearing in object explorer how to get database back to object explorer help me in detail
Posted 25-Sep-12 23:19pm
Updated 25-Sep-12 23:20pm
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

I guess, you are looking for this: MSDN: Attach a Database[^]
  Permalink  
Comments
Ankur\m/ 26-Sep-12 4:54am
   
I refreshed the screen before adding the answer, it showed me nothing. Suprisingly the time difference between the answers is about 5 mins. :omg:
Sandeep Mewara 26-Sep-12 9:09am
   
Not an issue. Have 5 for the same link ;)
Ankur\m/ 26-Sep-12 9:24am
   
Ah... I guess I forgot the concept of 5 in Q&A. I have not been voting here recently. Let's start with yours.

And thanks! ;)
Sandeep Mewara 26-Sep-12 9:25am
   
:)

BTW, So does that mean you are back for more answers and time for Q&A now?
Ankur\m/ 26-Sep-12 9:30am
   
I am not sure. I visit here whenever I get time. This week was good in terms of work load so I was here. I know it won't last very long. :(
Sandeep Mewara 26-Sep-12 9:31am
   
Okie.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

I am considering you are using SQL Server Management Studio.

Connect to the server you want the database in. Right click the database folder and say "Attach". A screen will come up and you will need to provide details like the mdf file of the database.

Get more details here: MSDN - Attach a Database[^]
  Permalink  
Comments
Sandeep Mewara 26-Sep-12 9:09am
   
5 for the linked answer. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100