Scripting Error

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  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!

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  September 4, 2003 at 11:47 pm

  #472728

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

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  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!