Save database object with dbo instead of schema-Domain name + dbo

Posted on 2012-09-05
Last Modified: 2012-09-13
Everytime I save a view or object it adds my schema  like

How can I save a view as dbo owner without the long schema name ?

and if I have save it already how will I chanegre it? thanks
Question by:zachvaldez
    1 Comment
    LVL 16

    Accepted Solution

    "   create view dbo.fred as   "  instead of   "   create view fred as   "

    should let you save it as DBO, assuming you have the right privileges. If not, talk to your friendly DBA.

    To change a view, open it using the SCRIPT AS ... ALTER VIEW   when you right click it and change the  "   alter view myname.fred as  "  to  "   create view dbo.fred as  " and run the code

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    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.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    758 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