I might have 3 apps open at the time. Lotus Notes, SQL Server Enterprise Manager and SQL Query Analyser. I am working in SQL Analyser and everything is fine. I run some queries, maybe 20 rows returned - nothing big. Then after a period of time, if I try to switch to Lotus or Enterprise Manager - they dont open. They are highlighted in the task bar, but the window is the Analyser window. Sometimes "part" of the app I am selecting shows, but it doesnt get focus. I select SQL Analyser from the task bar and it goes back into Analyser, fully functional and I can run queries etc as normal.
If I CTRL+ALT+DEL, that freezes as well, I can see what processes are running.
HOWEVER. If i switch back to SQL Query Analyser and close down the application - everything returns to normal.
Why? Is this a memory issue? Should SQL be reinstalled?
These problems just started to occur 3 days after installing Office 2003.
Using Windows 2000 and SQL 2000.