Forum Discussion
Adventureworks data does not load in SSMS
Hello, I am a new member here so forgive me if I am not posting in the right spot. I have been trying to load data using a script for the AdventureWorks database. I used the creation script from th...
Was your installation following the description of script?
It is located at the beginning of the script file. This 'How to...' is come from _DW script. If you were using another script, check the same place.
/*
* HOW TO RUN THIS SCRIPT:
*
* 1. Enable full-text search on your SQL Server instance.
*
* 2. Open the script inside SQL Server Management Studio and enable SQLCMD mode.
* This option is in the Query menu.
*
* 3. Copy this script and the install files to C:\Samples\AdventureWorks, or
* set the following environment variable to your own data path.
*/
:setvar SqlSamplesSourceDataPath "C:\Samples\AdventureWorks\"
/*
* 4. Append the SQL Server version number to database name if you want to
* differentiate it from other installs of AdventureWorks.
*/
I don't understand your question? Are you saying that a DW script may be inappropriate?
I mean, before you run the script, read the instructions at the beginning of the script file.