Is it possible to add an optional parameter to the connection ? Such as ‘application name’ or ‘app’ (ex: application name=NCC-USER01 or app=NCC-USER01) . In our databases and client applications we have a lot of views that handle app_name() for security reasons. with ms sql managment studio 2008 it is possibile to set that parameter for the connections. Not with the 2005 version.
Now Toad report me ‘Toad for Sql Server’ as app_name().