ok, now that i understand the syntax, could someone please help me giving me the order / commands to run to :

create a new database using a dump made on...

ok, i understood, i just have removed all the "GO" statments and all seems to work now ;-))

But should i add a "GO" anywhere then ?

Sorry Bill, i'm not sure to understand.

My goa lis t ocreate 1 only sql script that will perform many tasks in order to:

delete a nexisting Database

Create a new daztabase with...

Very strange, there is something i must miss somewhere :

USE master

GO

DECLARE @DB_Name varchar(128)

DECLARE @DB_Bak_file varchar(128)

DECLARE @DB_Import_file varchar(128)

DECLARE @DB_Datas_Path varchar(260)

DECLARE @DB_Logs_Path varchar(260)

DECLARE @DB_Login varchar(128)

DECLARE @DB_Password varchar(128)

DECLARE @SQLString nvarchar (2000)

-- Nom de...

ok, it worked, now i get a new error few lines after :

-- Creation de la nouvelle base de données

SET @SQLString = 'CREATE DATABASE ' + @DB_Name + ' ON...

Hi,

may i just create a batch file calling "osql.exe mysqlscript.sql" command to execute the restore instead of creating it into SQL itself ? i'm not good at jobs into SQL...