dbo Prefix after migrate from MS SQL 2000 to 2005

Posted on 2008-11-13
Last Modified: 2012-05-05
There is already a question with the same problem "Restoring SQL Server 2000 db to SQL Server 2005 db user issues" posted with a solution "I got it.  It seems there is an order to things.  I can now run the sp's either way.  I don't have time to write it up but I will in case someone else runs into this issue."

But I can't find the solution in detail. How is it possible to get the solution.

Many thanks
Question by:go_radical
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    are you speaking of this question:

    now, what is your exact problem?
    LVL 51

    Accepted Solution

    The schema for many system tables changed in SQL 2005.  However, it's backward compatible and if you restore a SQL 2000 DB on SQL 2005 it will honor the old system table names.

    Using the 'dbo' prefix is recommended because it improves performance.  In some cases it can be substantial.  For example, SQL won't cache execution plans for store procedures that don't use the dbo prefix within.

    Many people mistakenly think that adding the prefix simply prevents an owner lookup (which is correct) however, it's far more than that.

    I manage a team of developers and if they don't use the prefix they don't pass code review.

    Author Closing Comment

    OK! I changed all the prefixes in the code to dbo. Now everything works fine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now