The SQLmag Database DDL Script File

To obtain the Data Definition Language (DDL) script to create the SQLmag database, download the script file above, and execute it on your SQL Server. I've tested the DDL on SQL Server 2000 and SQL Server 7.0. At the beginning of the script, you'll have to make some changes and adjustments to filenames and so forth to account for your environment.

I haven't tested the DDL on SQL Server 6.5, but the best way to generate this script on your 6.5 server is to use Enterprise Manager to create devices (one for the data file and one for the log) and the database, then run the DDL script from the first CREATE TABLE statement on.