Options
@ptrval problems
obergman
Posts: 5
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
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
This discussion has been closed.
Comments
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.