[Share] Creating Fresh new database

This script is use to create Fresh Database of RanGame1,RanShop , RanLog and RanUser as a
replacement of rangame1.bak ,ranlog.bak ,ranshop.bak ,ranuser.bak

just double click each file and it will open to the Query Window on SQL management studio. then press Execute

now u have fresh database created by scripts .Usernum counting also will start at 1

this scripts is generated by Management Studio and tested successfully ^^


for SQL 2000 use Query Analyzer to execute the script


SQL Script Database for using SQL Express 2005 [20kb]
http://ianznet.110mb.com/ran/sql_2k5.zip

SQL Script Database for using SQL Server 2000 [20kb]
http://ianznet.110mb.com/ran/sql_2k.zip

ranlog database is still present on your mssql. delete this db first before executing the files attached

note:
only execute those files if you're creating a "new" server

yah you nid to delete your old database...
but before anything else you nid to have a backup files of your old database just in case
if get some errors...

Updated now Supports SQL 2000 for users Using

SQL 2000 Evaluation
SQL 2000 Personal Edtion or Standard Edition
SQL 2000 Enterprise Edition

Complitable Database sir?.

wooh, what the bump :D LoL