I did the same test as Bryan with the same result.  The object qualifier seems to be the catch here.

I tried running the sql as a script and it threw back an error;

System.Data.SqlClient.SqlException: Line 20: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure dbo.nuke311_grmGetRepositoryModules @PortalId int as SELECT TabModules.TabID AS TabID, Modules.*, Modules.PortalID AS PortalID FROM dbo.nuke311_ModuleDefinitions INNER JOIN dbo.nuke311_Modules ON dbo.nuke311_ModuleDefinitions.ModuleDefID = dbo.nuke311_Modules.ModuleDefID INNER JOIN dbo.nuke311_TabModules ON dbo.nuke311_Modules.ModuleID = dbo.nuke311_TabModules.ModuleID WHERE (dbo.nuke311_ModuleDefinitions.FriendlyName = N'Gooddogs Repository') AND (dbo.nuke311_Modules.PortalID = @PortalId) and dbo.nuke311_Modules.IsDeleted=0 order by TabId GO

I'm getting the same error on the dashboard. The dashboard appears on the portal but does the "Object reference error" when I click on the dashboard settings link. I ran the SQL script shown above and it generates the following error - -

System.Data.SqlClient.SqlException: The column prefix 'TabModules' does not match with a table name or alias name used in the query. The column prefix 'Modules' does not match with a table name or alias name used in the query. The column prefix 'Modules' does not match with a table name or alias name used in the query. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure dbo.WW2Waypoints_grmGetRepositoryModules @PortalId int as SELECT TabModules.TabID AS TabID, Modules.*, Modules.PortalID AS PortalID FROM dbo.WW2Waypoints_ModuleDefinitions INNER JOIN dbo.WW2Waypoints_Modules ON dbo.WW2Waypoints_ModuleDefinitions.ModuleDefID = dbo.WW2Waypoints_Modules.ModuleDefID INNER JOIN dbo.WW2Waypoints_TabModules ON dbo.WW2Waypoints_Modules.ModuleID = dbo.WW2Waypoints_TabModules.ModuleID WHERE (dbo.WW2Waypoints_ModuleDefinitions.FriendlyName = N'Gooddogs Repository') AND (dbo.WW2Waypoints_Modules.PortalID = @PortalId) and dbo.WW2Waypoints_Modules.IsDeleted=0 order by TabId