The problem i am facing is, When using off the XXXX application software, for example TOAD for SQL Server, we get a SQL Server Database Error, Cannot resolve collation conflict for equal to operation, causing the software to not function properly.
i need to change msdb database collation from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1_CI_AI
What makes you think that problem is caused by the collation of MSDB? It seems unlikely that the TOAD application is at fault. Presumably your own code is the cause. Have you used Profiler to capture what SQL is actually being executed?