if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkemailandsecques]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkemailandsecques]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordandsecques]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordandsecques]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordbyuid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordbyuid]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordbyusername]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordbyusername]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createadmingroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createadmingroup]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createattachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createattachment]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createfavorite]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createfavorite]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpm]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpm]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpoll]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpost1]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createsearchcache]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createsearchcache]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createtopic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createtopic]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createuser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createuser]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletepost1bypid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletepost1bypid]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deleteps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deleteps]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletespace]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletespace]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletetopicbytidlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletetopicbytidlist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getadmintopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getadmintopiclist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getalbumlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getalbumlist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getalltopiccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getalltopiccount]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoritescount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescount]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoritescountbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescountbytype]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslistbyalbum]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslistbyalbum]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslistbyspacepost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslistbyspacepost]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfirstpost1id]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfirstpost1id]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getforumnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getforumnewtopics]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getlastpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getlastpostlist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getmyposts]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getmyposts]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getmytopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getmytopics]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getnewtopics]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getphotolist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getphotolist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpmcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmcount]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpmlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmlist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpoll]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpost1count]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpost1count]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpost1tree]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpost1tree]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostcountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostcountbycondition]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostlistbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlistbycondition]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getshortuserinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getshortuserinfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getsinglepost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsinglepost1]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getsitemapnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsitemapnewtopics]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccount]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiccountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccountbycondition]
GO
if exists (select * from dbo.sysobjects where id = o