Post reply

cant rename udfs

  • January 16, 2004 at 4:46 am

    #84351

    Hi,

    In my db I can rename the sprocs etc but I can't rename the udf's.

    I've looked thru permissions etc, and can't seem to find the answer.Is there something that makes a udf inherently differnt from a sproc when it comes to renaming?I doubt it, but i have to ask.

    If not, does anyone have a checklist/ pointers?I've already given permissions on the udf for SELECT and DRI.

    ta folks,

    yogiberr.

     

  • January 16, 2004 at 5:27 am

    #490394

    Did you use sp_rename?



    --Jonathan

  • January 16, 2004 at 5:29 am

    #490395

    no,

    I tried to do it thru EM, would that make a difference?

    yogi

  • January 16, 2004 at 5:35 am

    #490397

    Cheers Jonathan,

    That worked. Is it a bug in EM?, Surely I have the same permissions whether I do it thru EM or sp_rename ?I'd love to know.

    btw, i'm on sql2k.

    ta,

    yogi.

     

  • January 16, 2004 at 6:24 am

    #490402

    Apparently. 

    "Real DBAs don't use Enterprise Manager." 



    --Jonathan

  • January 16, 2004 at 6:30 am

    #490403

    aye, point taken.

    I'm trying to wean myself off of EM, though i don't think i'll be making the real dbas christams card list just yet.

    ta,

    yogi

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply