DNN932: If you rename a page, a redirect is generated. Useful, but not during development of a site where page names are changed frequently.
I want to remove all the page redirects just before putting the site live.
Does anybody have an SQL statement that I can use to do the cleanup in one go?
AFAIK: DELETE From TabUrls Where [HttpStatus] = '301'
Posted By Sebastian Leupold on 16 Oct 2019 07:01 AM DELETE FROM TabUrls WHERE HttpStatus = 301
:-)
Posted By Timo Breumelhof on 16 Oct 2019 07:02 AM AFAIK: DELETE From TabUrls Where [HttpStatus] = '301'
Thank you both.
I think I will apply:
DELETE FROM {databaseOwner}[{objectQualifier}TabUrls] WHERE [HttpStatus] = '301'
Joe,
they are not identical. Sebastian wrote:
[...] WHERE HttpStatus = 301
Timos answer was:
[...] WHERE HttpStatus = '301'
As the column HttpStatus is nvarchar(50), Timos answer is syntactically correct, even if Sebastian's answer will work as well (because SQL Server does an implicit conversion...)
Happy DNNing! Michael (smart alleck) :-)
Michael TobischDNN★MVP
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.