Personally I don't think that runing the script is the problem; because the script was generated on a different server it may well be completely inappropriate for the current environment (location of files etc. or assumption that DB, of specific name, exists, or chance that that DB does exist and is pre-DROPPed / whatever). Also the need to check for errors - all the output is going to go flying up the screen!! and even if diverted to file if the script is full of INSERT statements (and no NOCOUNT statement) it would be impossible to see the wood for the trees ...)
As I said earlier, but O/P has not bothered to respond, I don't think it is possible for someone with no experience of SQL to create and populate a database from a "database dump" script provided by 3rd party and using only Forum for assistance.
it needs either:
-
Some help from someone with enough SQL experience to be able to review/adjust the script to run safely and make sure that any errors are both found AND dealt with (including ignoring them if it is deemed safe & appropriate to do so ...)
-
Get the original provider to provide a Database BACKUP. That would be trivial, by comparison, to get help from a Forum to RESTORE. Note that the backup must be made from a version of SQL that is not newer than the O/P's and also not more than 2 versions earlier. (It is not possible to Restore backups from "very old databases" onto a "much newer version").
But I am talking to myself so will now give up.