Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
The SQLmag Database DDL Script File
Download this Data Definition Language (DDL) script to create the SQLmag database that Michelle A. Poolet uses in her October Solutions by Design article.
Michelle A. Poolet
September 20, 2000
1 Min Read
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.
About the Author(s)
You May Also Like
