• subscribe
September 21, 2000 12:00 AM

The SQLmag Database DDL Script File

SQL Server Pro
InstantDoc ID #15620
Downloads
15620.zip

To obtain the Data Definition Language (DDL) script to create the SQLmag database, go to the SQL Server Magazine Web site (http://www.sqlmag.com/), copy the script, 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.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...