Answer / Rohit

Follow these steps: 1) Create a directory where you want to store the AdventureWorksLT data files. 2) Download the data files from <https://github.com/Microsoft/sql-server-samples/releases> and unzip them into the directory created in step 1. 3) Run SQL Server Management Studio, connect to your server instance, and right-click on Databases -> Attach -> Add database dialog box. 4) Navigate to the directory containing the data files, select the .mdf file for the AdventureWorksLT database, and click OK.

Explain steps of normalization?

1 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

1 Answers  

---

How to drop an existing stored procedure in ms sql server?

1 Answers  

---

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

---

How to write a query with a left outer join in ms sql server?

1 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

1 Answers  

---

what is database replicaion? : Sql server database administration

1 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1 Answers  

---

How to disconnect from a sql server using mssql_close()?

1 Answers  

---

How the data stores in a page?

1 Answers  

---

Can we call stored procedure in trigger?

1 Answers  

---