We are running a client application from which the query gives back results very slow or it times out if an ordinary user runs it, these users are all member of a domain group and the sql role of this group is public.
Whenever we run the same application from the same workstation as the domain admin which has a direct login on the sql server it gets its results within two or three seconds.
What could be the issue here?
Regards Peter.