DotNetNuke - Reset LoginTabId of a portal

Hey friends,
lots of time in DotNetNuke development, we change the default LoginTabId from site settings for portal 0 and forget to add the login module in the newly added tab. That will cause you into the problem. You can reset it by executing the following t-sql script:

update Update {databaseOwner}{objectQualifier}Portals
Set
   LoginTabId=NULL
Where PortalId=@portalid
-- by default if its in portal 0 with no qualifier then you can execute
--update Update dbo.Portals
--Set
--   LoginTabId=NULL
--Where PortalId=0