[Share] Creating Fresh new database

[ianotida]

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

[MentaL]

[jopax]

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

[kelvin_112]

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...

[ianotida]

Updated now Supports SQL 2000 for users Using

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

[buangnaka]

Complitable Database sir?.

[Eil Nahd]

wooh, what the bump :D LoL