Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Need help from someone who thoroughly understands how DNN uses tables.Need help from someone who thoroughly understands how DNN uses tables.
Previous
 
Next
New Post
9/26/2006 10:16 AM
 
Shawn Duggan


www.t4g.com
Joined: 8/19/2005
Posts: 303
I don't know if this will help or not, but to provide a little more supporting info on the way SQL Server works, when you are logged into EM and create objects they will be prefixed with your credentials.  If you have dbo privs, then it would be dbo.  If not, it will be your credentials as you've found. 

When a request is made in the database for an object, the default returned will be the one owned by the id you are logged in with unless you specify the owner of the object.  For example, if there are 2 tables, user.products and dbo.products....if you are logged in with an account named user, when you issue "select * from products" you will be getting the data from user.products.

I agree that life is simpler if there is only one owner of objects.  Your data is likely in the tables owned by your own id though, so don't simply drop them if the dbo has a version too.  You may need to drop the dbo objects (be careful which ones as mentioned) before changing ownership of your tables back to dbo (if you can).  However, the next time you run an upgrade if your account is not dbo you could be back in the same situation.

Don't forget to back up the database before you try anything.  :)  Once bitten twice shy.
Shawn Duggan MCPD
BlueTango Software - Canada Web Content Management
Website Design | DotNetNuke Hosting | DotNetNuke Tips and Tricks Blog
AuthIntegrator - The Easy Way To Integrate DNN and ASP.NET Applications
KeepAlive - Why Should Your Site Be Slow?
 
New Post
9/26/2006 6:14 PM
 
James Brown


Joined: 6/29/2004
Posts: 319
Much of what you have both told me is what I suspected.  This also leads me to believe that the problems I have been having with upgrades are due to an "anomaly" in DNN ver 3.3.5.  DNN is issueing SQL statements specifying "username.sysobjects", (see the error referenced my the original post) but apparantly the owner of the table  "sysobjects" should always be "dbo"and not "username".  This works just fine if they BOTH happen to be "dbo" but my ISP assigns the username as the owner to non-system created files.  This has not been a problem with versions through DNN 3.2.2 - since the system tables were not referenced by the username. 

I don't want to go through  process of changing ownership, since I will have the same problem next time  upgrade and it may cause problems everytime I add a new module, since the ownerhip is automaticly going to be the username.  I'm not even sure it will solve the immediate problem.  Also I do not think the script that john posted deals with the stored procedures.

For the time being, i would like to change the particular reference that is causing the problem, but I do not know where it lives.  I also think it should be submitted as a bug.

So, anyone know how to find the references to "sysobjects" and change them so that the username is not prepended as the database owner?
 
New Post
9/29/2006 5:16 AM
 
Laurence Neville


Joined: 11/2/2003
Posts: 383
The reference is probably in a stored procedure, or possibly a view or user defined function. One way to find it is to go to the \Providers\DataProviders\SqlDataProvider folder in DNN and look through the files from 03.02.03.SqlDataProvider to 03.03.05.SqlDataProvider. These contain all the SQL database changes that are installed in an upgrade from 3.2.2 to 3.3.5. What you are looking for is the text {databaseOwner}{objectQualifier}sysobjects or maybe just {databaseOwner}sysobjects.

Another way to do it is to script all the stored procedures views & defined functions in your database and look though the script. You will need SQL Enterprise Manager/Management Studio to do this.
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Need help from someone who thoroughly understands how DNN uses tables.Need help from someone who thoroughly understands how DNN uses tables.


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out