There was typing mistake in the query I posted in the forum, the actual query does has alias in place (see the updated query below). The query does not work...

Yes, putting square brackets around external does solve the problem. But we are trying to avoid any code changes and looking for any other possible options.

We considered using application roles, but we read there are some problems accessing multiple databases if guest login is disabled on other databases. In our application we have exact same...

You can try something like this. With this query if there are two records with same minimum date then it will return two records

select table1.*

from table1,

...

Florian, Jonathan,

Thank your very much for your help. The sample codeproject code helped !!.

I understand I don't have to specify username/password. But is there anyway to go thru windows authenication by providing windows username/password while establishing the DB connection or to override credentials...

Hi Flo

There is no script between job and executable. I'm handling any errors thrown by executable in try, catch block and may be because of that it now logged in...

Hi Flo

There is no script between job and executable. I'm handling any errors thrown by executable in try, catch block and may be because of that it now logged in...

The job is going thru fine and it is not showing any errors, the executable called from the job is throwing the error. But when same executable is launched manually...