Post reply

Scripting Error

  • September 4, 2003 at 11:34 pm

    #83161

    Greetings.

    Trying to script all my procs and functions and keep getting this error.

    Error 21305: [SQL-DMO] Unexpected parameter or other condition.

    Anybody seen it or know why?

    MS search yields nothing..

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • September 4, 2003 at 11:47 pm

    #472728

    Not much but have a look at http://dbforums.com/arch/72/2002/12/635572

  • September 5, 2003 at 12:00 am

    #472729

    Actually just worked out why.

    I had the list of procs open and selected all, script.

    Error.

    Another guy could script them.

    I dropped a proc and he then got the same error.

    He had dropped a proc earlier and I had not refreshed the view.

    Seems if you add a proc or drop one and try script the using EM without refreshing the view, it dies.

    EM probably uses the procs in it's current list and does not create a new list when scripting.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 3 posts - 1 through 2 (of 2 total)

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