table names changed in resotre

Posted on 2012-08-21
Last Modified: 2012-08-23
I took a sql database backup from my older website and restored it on the new one. Strangely all the tables got prefixed with a name and now all my queries/views/stored procedures are not working.

How do i resolve this?
Question by:RTKHOT
    LVL 9

    Expert Comment

    What was the prefix?
    Are the source database and the target database of the same version?
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    I presume what you see is that the "dbo/sa" account from the master server is not the default owner of the db.
    make sure the login you use to perform the restore does have db_owner permissions in the database, that should solve the problem of the default "dbo" prefix

    Author Comment

    the original prefix was dbo (it was an older sql version)

    in the new database, all tables have a prefix of the username (i guess)

    how do i change it back to dbo?
    LVL 142

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 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

    13 Experts available now in Live!

    Get 1:1 Help Now