hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution
Answer Posted / 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 |
Post New Answer View All Answers
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What do you understand by coalesce in sql server?
How to create an inline table-valued function?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Why do we use trigger?
What do you mean by recursive stored procedure?
Explain tablesample?
What is the difference between a clustered index and a non-clustered index?
what stored procedure would you use to view lock information? : Sql server administration
Can you explain what is the use of custom fields in report?
What do you mean by acid?
What are the differences between DDL, DML and DCL in SQL?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
List some major differences between triggers and stored procedures?
Give main differences between "Truncate" and "Delete".