hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the New in SQL server 2008?

727


What are different types of database indexes?

684


Name few of the dcl commands in sql?

712


What is the optimization being performed in oracle and SQL Server?

793


What is dbcc? Give few examples.

743






What is the difference between varchar and nvarchar?

677


Are semicolons required at the end of sql statements in sql server 2005?

725


Do you know query execution plan?

763


Characterize join and name diverse sorts of joins?

678


What are the operating modes in which database mirroring runs?

806


Can you tell me some of the common replication dmv's and their use? : sql server replication

708


How will you know when statistics on a table are obsolete?

800


What is page in sql server?

683


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

105


What is sqlservr.exe - process - sql server (sqlex?press)?

785