Cannot Create Stored Procedure

Posted on 2006-05-22
Last Modified: 2008-02-01
I'm trying to create a simple SP in SQL 2000 and I keep getting the error:

Microsoft SQL-DMO (ODBC SQLState:42000)
Error 2760:  Specified owner name 'OWNER' either does not exist or you do not have permission to use it.

I'm using MSDE and I've given the account I log into locally DBO.OWNER rights...I cannot figure this out...

Please help!!

Question by:clebo99
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    Check whether you have enough rights to create the stored procedure ? I think you won't have permissions
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    also make sure that you are on the right database where you have access, also the specified owner exists in the database
    LVL 7

    Accepted Solution

    Can you post an example of a procedure that won't work?

    I am guessing from your question that you are using something like



    If so, you should use this syntax:

    CREATE PROCEDURE MyDB.dbo.MyProcedure

    The alias "dbo" is automatically translated to the database owner ID.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Database tuning – How to start and what to tune. This question is frequently asked by many people, both online and offline. There is no hard and fast rule-of-thumb for performance tuning, however, before beginning the tuning process one should a…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    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

    10 Experts available now in Live!

    Get 1:1 Help Now