Command Text error
Brian Donahue
Posts: 6,590 Bronze 1
Hi Peter,
Nice to hear from you again. There is a known problem with SQL Compare
that may be responsible for this. It has to do with stored procedures that
are larger than 40K or so. SQL Compare tries to save time by only loading
part of the stored procedure, and that's what causes the problem.
I'm sending a patch to fix this directly to your email address.
Thanks,
Brian Donahue
Red Gate Technical Support
"Peter Thistleton" <peter.thistleton@achievehealthcare.com> wrote in message
news:3fP7F9OnDHA.1472@server53...
> When running some scripts through SQL Compare synchronization interface I
> receive the following error:
>
> ExecuteNonQuerey: Command Text property not initialized.
>
> The scripts work fine from Query Analyzer.
>
>
Nice to hear from you again. There is a known problem with SQL Compare
that may be responsible for this. It has to do with stored procedures that
are larger than 40K or so. SQL Compare tries to save time by only loading
part of the stored procedure, and that's what causes the problem.
I'm sending a patch to fix this directly to your email address.
Thanks,
Brian Donahue
Red Gate Technical Support
"Peter Thistleton" <peter.thistleton@achievehealthcare.com> wrote in message
news:3fP7F9OnDHA.1472@server53...
> When running some scripts through SQL Compare synchronization interface I
> receive the following error:
>
> ExecuteNonQuerey: Command Text property not initialized.
>
> The scripts work fine from Query Analyzer.
>
>
This discussion has been closed.
