if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_admingroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_admingroups]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_adminvisitlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_adminvisitlog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_advertisements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_advertisements]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_albumcategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_albumcategories]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_albums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_albums]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_announcements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_announcements]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachments]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_attachtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachtypes]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_bbcodes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_bbcodes]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_creditslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_creditslog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_failedlogins]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_failedlogins]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_favorites]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_favorites]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_forumfields]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forumfields]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_forumlinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forumlinks]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forums]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_help]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_help]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_medals]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_medals]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_medalslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_medalslog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_moderatormanagelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_moderatormanagelog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_moderators]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_moderators]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_myposts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_myposts]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_mytopics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_mytopics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_online]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_onlinelist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_onlinelist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_paymentlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_paymentlog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_photocomments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_photocomments]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_photos]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_photos]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_phototags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_phototags]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_pms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_pms]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_polls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_polls]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_postid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_postid]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_posts1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_posts1]
;


if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_ratelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_ratelog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_searchcaches]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_searchcaches]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_smilies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_smilies]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spaceattachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spaceattachments]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacecategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacecategories]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacecomments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacecomments]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spaceconfigs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spaceconfigs]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacecustomizepanels]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacecustomizepanels]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacelinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacelinks]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacemoduledefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacemoduledefs]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacemodules]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacemodules]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacepostcategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacepostcategories]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spaceposts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spaceposts]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spaceposttags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spaceposttags]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacetabs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacetabs]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_spacethemes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_spacethemes]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_statistics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_statistics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_tablelist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_tablelist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_tags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_tags]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_templates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_templates]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_topicidentify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topicidentify]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_topics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_topictagcaches]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topictagcaches]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_topictags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topictags]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_topictypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topictypes]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_userfields]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_userfields]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_usergroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_usergroups]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_users]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_words]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_words]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkemailandsecques]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkemailandsecques]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordandsecques]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordandsecques]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordbyuid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordbyuid]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_checkpasswordbyusername]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkpasswordbyusername]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createadmingroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createadmingroup]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createattachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createattachment]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createfavorite]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createfavorite]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpm]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpm]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpoll]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createpost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpost1]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createsearchcache]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createsearchcache]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createtopic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createtopic]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_createuser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createuser]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletepost1bypid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletepost1bypid]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deleteps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deleteps]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletespace]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletespace]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_deletetopicbytidlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletetopicbytidlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getadmintopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getadmintopiclist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getalbumlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getalbumlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getalltopiccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getalltopiccount]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoritescount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescount]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoritescountbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescountbytype]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslistbyalbum]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslistbyalbum]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfavoriteslistbyspacepost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslistbyspacepost]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getfirstpost1id]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfirstpost1id]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getforumnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getforumnewtopics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getlastpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getlastpostlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getmyposts]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getmyposts]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getmytopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getmytopics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getnewtopics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getphotolist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getphotolist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpmcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmcount]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpmlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpoll]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpost1count]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpost1count]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpost1tree]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpost1tree]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostcountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostcountbycondition]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getpostlistbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlistbycondition]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getshortuserinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getshortuserinfo]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getsinglepost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsinglepost1]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getsitemapnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsitemapnewtopics]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccount]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiccountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccountbycondition]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiccountbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccountbytype]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiclistbydate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbydate]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiclistbynumber]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbynumber]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiclistbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbytype]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettopiclistbytypedate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbytypedate]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_gettoptopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettoptopiclist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getuserinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getuserinfo]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_getuserlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getuserlist]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_shrinklog]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_shrinklog]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateadmingroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateadmingroup]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updatepoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatepoll]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updatepost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatepost1]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updatetopic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatetopic]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updatetopicviewcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatetopicviewcount]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateuserauthstr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserauthstr]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateuserforumsetting]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserforumsetting]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateuserpassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserpassword]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateuserpreference]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserpreference]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_updateuserprofile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserprofile]
;