I have created a new connection to MS SQL server (Toad 4.1.) due to an upgrade. I can run existing queries within Editor. But when I update connection in the existing .tas the query does not recognize the tables within structure of the db. I have never encountered this issue before. Please assist.
Does the sql in the automation file fully qualified? IE select col from database.owner.table;
The editor allows you to point to a database and not fully qualify the sql. The automation activity will use the default database of the connection if the sql is unqualified.
It seemed to do the trick! thank you Debbie. You are awesome
I call her the automation goddess but awesome is a good description too.