Hi,

did you run the script from SQL Server Management Studio or did you run it from Host :: SQL (from inside DNN)?

It worked fine for me when running it from Host :: SQL, if you run it from SSMS you hafe to find and replace {databaseOwner} and {objectQualifier} by its appropriate vales first (including the brackets!), eg. "{databaseOwner}" -> "dbo." and "{objectQualifier}" -> "dnn_".

Happy DNNing!
Michael

Remark: when you are not sure about databaseOwner and objectQualifier you can find these values in the web.config file:

<configuration>
   ...
   <dotnetnuke>
      ...
         <data defaultProvider="SqlDataProvider">
            <providers>
               <clear />
               <add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke"
                  connectionStringName="SiteSqlServer"
                  upgradeConnectionString=""
                  providerPath="~\Providers\DataProviders\SqlDataProvider\"
                  objectQualifier="dnn"
                  databaseOwner="dbo." />
            </providers>
         </data>

Happy DNNing!
Michael