Book a Demo

Author Topic: No definition when import sql server stored proc  (Read 2507 times)

raymondsing

  • EA User
  • **
  • Posts: 27
  • Karma: +0/-0
    • View Profile
No definition when import sql server stored proc
« on: August 31, 2006, 08:34:08 pm »
I import db schema of sql server stored proc.
Then generate rtf documentation.
Some stored proc has definition, notes and columns while some (mostly) do not.

Is there some setting or due to the way the stored proc was created?

(i tried the ea6.5 beta, same thing happened to stored proc and view)

Sql server 2000. Db is set to 6.5 compatibility.
EA is v6.1

any advise?

thomaskilian

  • Guest
Re: No definition when import sql server stored pr
« Reply #1 on: September 01, 2006, 09:48:10 am »
Not from my side. I just remarked a post with similar DB import issues. Maybe you exchange infos.

raymondsing

  • EA User
  • **
  • Posts: 27
  • Karma: +0/-0
    • View Profile
Re: No definition when import sql server stored pr
« Reply #2 on: September 06, 2006, 08:15:34 pm »
It seems that those sp that do not have definitions are because of error during importing - EA was not able to recognise the user-defined data type used in the sp.

I discovered this when i used a the version 6.1 build 792 to import sp and it complained of error - unrecognized symbol. AFter the importing process, i verified that these sp do not have definitions.

Is this a bug or limitation of EA?
« Last Edit: September 10, 2006, 07:22:29 pm by raymondsing »