Hi Kevin,
Could you give me the exact description of your error and also when you started to occur, with what version of DNN...? Cause maybe just maybe, we are talking about different problems here...
The errors that are returned when ruinning the SQL scripts is ok, as the sql is trying to create stored procedures or tables in your SQL database. The errors then state that certain tables already exists and cannot be created again, sot that should be no problem or that certain sp cannot be modified.
To be honest I haven´t used the DNN SQL tool myself, I myself have used the osql command and written a batch file so I was pretty much sure that sql dataprovider script was run.
Here´s a sample of the batch file.
Syntax:
osql -U sa -P <password> -d <database name> -s servername -i input_file -o output_file
Command line:
osql -U your_username -P your_password -d DNN4 -S intranet.slz.nl -i 04.00.00.SqlDataProvider -o 04.00.00.SqlDataProvider.log
Tip use excel to create the batch file quickly.
Good luck, hope this works!
Regards,
Jerry Tjon
IT Consultant
Amsterdam,
The Netherlands