Hello All,

        I have installed the latest dotnetnuke version in my production server.it was working fine ,unfortunately  i have deleted some tables from my live db,so its created the problem.so i want to delete the all tables,procedures,view and functions manually and try to reinstall the dotnetnuke,but i am not able to install dnn db.because of some dnn objects are not deleted completely,I have tried more than 5 times,i dont want to delete the existing database.

So please advise how to delete the exisiting dnn objects(eg:tables,procedures,views,schems...) completely and how to reinstall the nuke.

Thanks
Mani

Hey guys,

So I know this is pretty old, but it comes up from time to time...

Here's a script I've scraped together from somewhere (definitely not my own but I can't remember where/who should get the credit).

Anyway, it seems to do the job...you may have to run it more than once and you may get errors on the first run but it does work as of 5.6.2.

Hope it helps:

--DELETE ALL TABLES
declare @table_count int;
declare @iter int;
-- we know we're going to have tables the first time through
set @table_count = 1 ;
set @iter = 0;
-- check to see how many tables we have in the database
while @table_count > 0
begin
exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' ";
SET @table_count = (select COUNT(*) from sysobjects where type = 'U'and name <> 'dtproperties');
SET @iter = @iter + 1;
end
print 'iterations: ' + CAST(@iter as varchar);


--DELETE ALL VIEWS
declare @procName sysname

declare someCursor cursor FOR
SELECT name FROM sysobjects WHERE type = 'V' AND objectproperty(id, 'IsMSShipped') = 0

open someCursor
fetch next FROM someCursor INTO @procName
while @@FETCH_STATUS = 0
begin
exec('drop view ' + @procName)
fetch next FROM someCursor INTO @procName
end

close someCursor
deallocate someCursor
go

--DELETE ALL PROCEDURES

declare @procName sysname

declare someCursor cursor FOR
SELECT name FROM sysobjects WHERE type = 'P' AND objectproperty(id, 'IsMSShipped') = 0

open someCursor
fetch next FROM someCursor INTO @procName
while @@FETCH_STATUS = 0
begin
exec('drop proc ' + @procName)
fetch next FROM someCursor INTO @procName
end

close someCursor
deallocate someCursor
go