Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Can't upgrade		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

CaNgo
Starting Member

15 Posts
Posted - 20 August 2002 :  13:21:47  Show Profile
I try to upgrade my forums to 3.4. When running setup.asp it didn't see that I already got old version so it tried to create new tables. My old tables have "cango" owner and the new tables get "dbo" owner. How can I change the default dbowner from "dbo" to "cango"?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 20 August 2002 :  13:44:13  Show Profile  Send ruirib a Yahoo! Message
Execute these with Query Analizer:


exec sp_changeobjectowner 'old-owner.FORUM_BADWORDS' , 'new-owner'
exec sp_changeobjectowner 'old-owner.FORUM_GROUP_NAMES' , 'new-owner'
exec sp_changeobjectowner 'old-owner.FORUM_GROUPS' , 'new-owner'
exec sp_changeobjectowner 'old-owner.FORUM_MEMBERS_PENDING' , 'new-owner'
exec sp_changeobjectowner 'old-owner.FORUM_NAMEFILTER' , 'new-owner'


Thanks to Gremlin for this, since he posted about it at the moderators forum.

Snitz 3.4 Readme | Like the support? Support Snitz too
Edited by - ruirib on 20 August 2002 13:45:37
Go to Top of Page

CaNgo
Starting Member

15 Posts
Posted - 20 August 2002 :  14:19:31  Show Profile
Thank you Ruirib.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 20 August 2002 :  15:00:10  Show Profile  Send ruirib a Yahoo! Message
You're welcome .

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07