SharePoint users would love to use the hard-coded URLs in the SharePoint navigation. But they dont know what would be the impact while migrating site from one place to another and also it is really hard to find and replace these URLs as it’s time consuming.
SP administrator should have to use some tool to find out these hard-coded urls and change it manually. The below SQL query would point out the hard-coded URLs in each content databases. Also, I heard some webparts are available at the CodePlex.com to find and replace these hard-coded URLs.
use [CONTENT_DATABASE_NAME]
go
select webs.title as SiteName, navnodes.url as AbsoulteUrl, webs.fullurl as location
from navnodes
join webs on navnodes.webid = webs.id
where navnodes.url like ‘%http://%’
