hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution
Answers were Sorted based on User's Feedback
Answer / samba shiva reddy . m
Right click on Databases then click on attach it will pop window (Attach Database) then click on add button then select the .mdf file then automatically it will select the .ldf file
then click on Ok
that data base is ready for use.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / venkat reddy.ravu
First create a floder on the drive.copy and paste .mdf
and .ldf files into that folder.
Connect to database engine
|
Object Explorere
|
Databases(Right click)
|
Attach
select the .mdf file ,then .ldf will be automatically
selected.in the pouup window window you will bew asked to
enter the database name.
Is This Answer Correct ? | 0 Yes | 0 No |
Can you explain powershell included in sql server 2008?
Differentiate between a having clause and a where clause.
What does executeupdate return?
What is history table in sql server?
What is a virtual table in sql?
What is the purpose of object explorer and its features? : sql server management studio
Differentiate between mongodb vs. Sql server?
What are the types of lock supported by ?
Is resultset an interface?
Why use “in” clause in sql server?
What is the library index called?
Tell me the difference between clustered and non-clustered index?