I have scripted the entire database with a believe that the script copied all the objects. Now how do I run the script in the new server sql database, below the attached scrprit.
Nector,
What generated the script?
For most of it. You could run it in SSMS from the master database.
The embedded \r \n stuff makes it seem the file originated from a Unix system/utility.
Otherwise, the database can't exist on the server where you run the script.
The datatype nvarchar really makes as though the original database was made through a utility and still needs some work.
Tough typing on a phone.
Wayne
