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.

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.

How does normalization work?

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is indexing and its types?

0 Answers  

---

Why do you need a sql server?

0 Answers  

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

What is a sub-query? When would you use one?

3 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

Explain full-text query in sql server?

0 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---