May 09, 2005 06:23 PM|Carritory|LINK
From what I can tell this has to do with issues around the table and Stored procedure script used to create the DotNetNuke database. The file used to create everything is DotNetNuke.Schema.SqlDataProvider.
If you are creating your DotNetNuke database on a SQL Server which has been configured as "Case Sensitive" then certain stored procs fail to get created. An example of this would be GetTabByName. Search your DotNetNuke folder for the DotNetNuke.Schema.log
file. When opened you will see there are number of stored procs which failed to get created.
These failures occur because the table was created with the field "PortalID" but the script is trying to create the stored procedure with "PortalId" or some variation different then the field in the source table.
I'm going to post a separate thread and name it Case Sensitive SQL Server Install Failure to see if I get some help.
Under a Case Sensitive SQL Server you have the option to create a case insensitive database but my DBA had advised me that any temporary tables get created as part of a stored procedure call inherit the server setting so they would be created “Case Sensitive”
and this can result in stored procs failing for the same reasons outlined above.
I've tried to clean up the script myself but gave up.