COGNOiSe.com - The IBM Cognos Community

Hello,

We have a macro placed in our environment that runs against an ODBC connection to SQL Server and queries some tables against the database. When running manually, there are no problems, the macro runs smoothly. When setting it to run on a schedule against a particular user domain account, it errors with the following message:

"Invalid object name '[database]..

." (note the two dots between database and table). The default schema for the interactive user is "[database]", however the scheduled user default schema is "[dbo]". Is there a way of forcing the scheduled user to use the former schema rather than "[dbo]", without having to go into SQL Server and assigning the schema to it? Is there a statement that can be added to the actual macro to force it to use a particular schema, irrespective of what user may initiate the macro? Many thanks![/color]