Says invalid object name after renaming proc..

  • Try it, but I have a bad feeling we're missing something stupid...

  • Even restart did not help...still the same error....:crying:

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • NewBeeSQL (3/2/2011)


    Even restart did not help...still the same error....:crying:

    Like I said, we're missing something real stupid.

    Did you reset the permissions after creating the proc?

  • I just did a retest on my system and I can safely rename and un-rename the procs without any problems...

    Whatever you did is most likely not a direct effect of the rename, but something else.

  • am the db_owner...

    even i did renaming on other systems succesfully. i dont know what went erong this time....

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • Have you tried the restore path with reimport?

    I'd try that with your latest backup and the current copy of prod, but on a test server. See if that solves it.

  • NewBeeSQL (3/2/2011)


    am the db_owner...

    even i did renaming on other systems succesfully. i dont know what went erong this time....

    Are you able to call other procs from the same query window that fails with the renamed one?

    Tried refreshing the sp list in ssms to make sure the un-rename was successful?

  • NewBeeSQL (3/2/2011)


    am the db_owner...

    even i did renaming on other systems succesfully. i dont know what went erong this time....

    I don't know how urgent this is for your company, but you can always call MS directly (200-300$) and they'll help you over the phone.

    I'm heading out now so I can't provide help for a couple hours.

  • Yeah Ninja, I fear you're right, we're missing something obvious and just not asking the right questions.

    NewBee... can you do the following for me? I want to see what names your proc is listed as to the system:

    select o.name from sysobjects o where type = 'p' and name like '%_NR_%'

    Let's see what the system thinks these object's names are.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • OMG.........

    I figured it out.........The developer was writing stupid code inside proc which caused all these mess up.

    if you see the proc which i sent in my initial mail..there is a line saying

    SELECT @AlertMAsterID, dbo.sproc_NR_EWMDuplicateVIN.fk_DealerID,

    he is using proc name instead of a function..When i commented this select, it works...............

    Need to throw the developer out...............

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • *facepalm*

    I'd assumed the code worked before the whole namechange malfunction previously. Welp, that would certainly do it! Glad you figured it out.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 11 posts - 16 through 25 (of 25 total)

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