|
|
Directions for Creating the Ban Man Pro SQL™
Database. (SQL 7 and SQL 2000)
For SQL Server 2005 Express Instructions,
click here. |
-
The
banmanproSQL database is emailed as a script file called banmanpro.sql. Detach the file somewhere on your local computer.
-
From
within SQL Server Enterprise Manager, create a new database called
banmanproSQL. Right-mouse click on databases, then select New
Database.
-
Enter
a database name of banmanproSQL or another appropriate name.
-
Click
OK when finished and an empty is created.
-
Now execute the banmanpro.sql script to create the tables and queries in the
database. From the Tools menu of Enterprise
Manager, select SQL Server Query Analyzer.
-
From
within Query Analyzer, open the banmanpro.sql script file.
Select the banmanproSQL database from the DB: drop-down menu.
-
Execute
the script by clicking the green Execute Query
button.
If executed successfully, a message indicating 1 Rows Affected will
appear.
-
Make some optimization settings to the database.
Right click on the banmanproSQL database from within Enterprise
Manager. Select properties.
-
Under the options tab, select "Select Into/bulk
copy", "Truncate Log on Checkpoint" and
"AutoShrink".
This will keep the log file from growing to a large size.
| Note: In SQL
2000 Microsoft has removed the "Select Into/bulk
copy", "Truncate Log on Checkpoint" options. To
Control the Log file size in SQL 2000, be sure to create a
maintenance plan that performs a DAILY backup of both the
database and log file. The log file will then be
truncated each day after the daily backup. |
|
|
