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 |
what is diffrent between store procedure and trigger
What is the optimization being performed in oracle and SQL Server?
According to you what goes into making the best database administrator? : sql server database administration
Creating Tables Using SELECT
What does it mean to manipulate data?
Where is trigger in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are different types of data sources?
default databases available in sql server and there uses ?
What is importing utility?
what information is maintained within the msdb database? : Sql server administration
how to select a field with firstletter as capital and remaining are small letters
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)