Welcome to SQLDBcontrol Forums Sign in | Join | Help
in

unable to edit objects whose owner is not "dbo"

Last post 08-31-2006, 14:48 by admin. 0 replies.
Sort Posts: Previous Next
  •  08-31-2006, 14:48 54

    unable to edit objects whose owner is not "dbo"

    After creating a new project and setting up our databases, I checked out a user-defined function and made some changes to it.  When I try to save it, gives me Parse Error, The name of the object typed into the editor is different to the name of the object that you are editing.

     

    CREATE FUNCTION [etalk_live_user].[getAssociatedInvoiceTotal]

    (

      @userid               INT

    ) RETURNS BIGINT

    AS 

     

    BEGIN

      ...

     

      RETURN @Total

    END

    GO

     

    -Aaron

     

     

    Hi Aaron,

     

    I can confirm that this is a bug.  The problem lies with the fact that the object owner is not “dbo”.  For some reason it looks like we’re incorrectly displaying this message if the object owner (etalk_live_user in this case) is not a sysadmin.

     

    This has been resolved and will be released in the next maintenance release.  I have emailed you details of how to obtain an intermediate release containing the fix.

     

    If anyone needs this particular fix prior to release 1.4 please contact support@sqldbcontrol.com

     

    Thanks,

     


    SQLDBcontrol Support

    support@sqldbcontrol.com
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems