How to attach adventureworkslt physical files to the server?
- 1 Answers
- 1181 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
List the ways in which dynamic sql can be executed?
What is clustered index
How to remove duplicate rows from table except one?
What are the different subsets of sql?
How do I find the sql server version?
What is a coalesce function?
Where can you add custom error messages to sql server?
When should you use an instead of trigger?
What are the kinds of subquery?
What is an indexed view?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Why use identity in sql server?
What is self contained sub query?
How can you append an identity column to a temporary table?
