What are the challenges you face when working across database platforms? Take the survey

Command Text error

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited October 28, 2003 11:16AM in SQL Compare Previous Versions
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.


Brian Donahue
Red Gate Technical Support

"Peter Thistleton" <peter.thistleton@achievehealthcare.com> wrote in message
> 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.