Q:
In Mangagement Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified".
A:
TO Solve the above problem
Open task manager and end the DTASHELL.EXE process,then it should work.
