SQL Session View

If you recently switched from C/SIDE to SQL Server option, you may notice that the File / Database / Sessions view now shows all SQL connections including non Attain Clients, sa, etc. If you have to manage who is on and you don’t want to use SQLEM, then you can modify the Sessions view on your Attain SQL database. Add the following WHERE clause to the Sessions view: WHERE (CAST(SP.[program_name] AS NVARCHAR(128)) = ‘Navision Attain Client’) Then you won’t have to filter the File / Database / Sessions view when you are managing users inside the Navision SQL Client