@ptrval problems

obergmanobergman Posts: 5
edited August 30, 2005 5:48AM in SQL Packager Previous Versions
Hello,
I am executing a SQL-Packager script (>1 million lines) myself using DMO. When the variable @ptrval is referred to in the middle of the script I receive an error that it must be declared. References to @ptrval in the beginning of the script works fine. It seems to me that the variable is timing out. If this is true, how can I fix it?

Thanks,
Morten Bergman
The Burgess Group, LLC

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello Morten,

    I think that this may have to do with the transactional nature of the scripts produced by the Data Compare program. The keyword GO is something particular to Query Analyzer, so you may want to use the 'do not use transactions' option in the Data options before producing the script if you plan on using SQLDMO to run the actual SQL.
This discussion has been closed.