Error while generating schema using SQL stored Proc

Hi,

I am trying to generate schema using SQL Stored proc.  The wizard accepts all the configuration, and generates execute statement.  When I click next on statement information page, the wizard throws error that it cannot execute statement and syntax is wrong.

It is a simple stored procedure call without any parameters

Exec [name of sp]

I do not understand why it is not able to generate schema,

I appreciate all the help I get to resolve this issue.

PS:  I have made sure sql user i use to connect with, has execute permissions for this SP.

Thanks,

Angie