Hello, I am running a job that uses a cursor and dynamic sql to change the object owner of all the tables in a database. The problem is that the owner is changed for most of the tables, but not all. This varies with each running of the script.
If I run the scipt in Query Analyzer it works perfectly every time. It only has the problem when it is part of a scheduled job. Any ideas?
Thanks!
Ric
If I run the scipt in Query Analyzer it works perfectly every time. It only has the problem when it is part of a scheduled job. Any ideas?
Thanks!
Ric