Forum


HomeHomePublicPublicTips and TricksTips and TricksAdd "{databaseOwner}{objectQualifier}" to SQL script table namesAdd "{databaseOwner}{objectQualifier}" to SQL script table names
Previous
 
Next
New Post
11/14/2013 3:24 PM
 

In case anyone has problems running scripts from Host > SQL with such as this one from the Fixing "404 Page Not Found" after a DNN 7.1 Upgrade - Part 2/2 article:

Select * From Tabs Order By TabID Desc

You might need to put "{databaseOwner}{objectQualifier}" before any table names if you specified an "object qualifier" such as "dnn_" when you created the installation. For example:

Select * From {databaseOwner}{objectQualifier}Tabs Order By TabID Desc

 
New Post
11/15/2013 2:05 AM
 

Thank for the great tip Larry. You are completely right!

Cheers,

Aderson

 
Previous
 
Next
HomeHomePublicPublicTips and TricksTips and TricksAdd "{databaseOwner}{objectQualifier}" to SQL script table namesAdd "{databaseOwner}{objectQualifier}" to SQL script table names



Try FREE
30 days money back guaranteed