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
What are trace flags and mention a few common trace flags used with sql server?
can an automatic recovery be initiated by a user? : Sql server administration
How can sql server instances be hidden? : sql server security
Difference between LEN() and DATALENGTH() in sql server ?
What is single-user mode?
Explain what is it unwise to create wide clustered index keys?
What is scheduled job and how to create it?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the server name for sql management studio?
What is a database in ms sql server?
How will you optimize a stored procedure optimization?
What are different types of constraints?
What is the full form of dql?
last function used in MS Access to convert sql what function will use in sql
what is the difference between openrowset and openquery?