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.

What is merge statement?

1076

---

which table keeps the locking information? : Sql server administration

1082

---

How real and float literal values are rounded?

1153

---

What is 3nf normalization form?

1111

---

How do I partition a table in sql server?

1039

---

Explain what are the different index configurations a table can have?

1109

---

What is xdr?

987

---

What does the not null constraint do?

1084

---

How to list all user defined functions in the current database?

1041

---

What is difference between stored procedure and user defined function?

1103

---

What is replication and database mirroring?

1047

---

What is the difference between count () and rowcount ()?

1024

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1389

---

Does any body please help me what question's have asked for SSRS in the interview?

2148

---

What are different types of table joins?

1003

---