Step 2: Preparing SQL Server for the CSF Headlines Sample
To prepare Microsoft SQL Server for the CSF Headlines sample, perform the following procedure. The CSF Headlines sample must be installed before continuing.
To prepare SQL Server for the CSF Headlines sample
Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
In the Connect to SQL Server dialog box, do the following:
Use this To do this SQL Server Type the name of the SQL Server. Connect using Select SQL Server authentication. Login Name Type your SQL Server login name. Password Type your SQL Server password. Click OK.
In the SQL Query Analyzer screen, on the Query menu, click Change Database.
In the Select Database dialog box, select CSFHeadlines_commerce, and then click OK.
On the File menu, click Open.
In the Open Query File dialog box, navigate to <drive:>\Program Files\Microsoft Commerce Server\SDK\Samples\Marketing\Headlines\SQL, select headlines_config.sql, and then click Open.
On the Query menu, click Execute.
On the File menu, click Open.
In the Open Query File dialog box, navigate to <drive:>\Program Files\Microsoft Commerce Server\SDK\Samples\Marketing\Headlines\SQL, select sample_headlines.sql, and then click Open.
On the Query menu, click Execute.
On the File menu, click Exit.