Using SQL Assistant

I sucessfully installed SQL Assistant. It now shows up as a red SQL in the toolbar. However nothing happens. I am using Query analyzer to access SQL Server and the is no prompt, nothing changes to uppercase. Its as if the product is not installed. When i right click on the SQL icon, the menu reads SUSPEND, OPTIONS ABOUT EXIT. I tried suspending it which works, then resuming it which aslo works but to no effect. I tried to manually invoke SQL assistant with Ctlr=Space but still nothing.

I am running Windows XP professional, SQL Server 2000, SQL Assistant 1.044

Any suggestions to make SQL Assistant do something?

Very strange. Try this, right click on the icon in the system tray, click Options menu item; On the Options dialog click Targets tab and ensure MS Query Analyzer item is checked.

If it doesn't help, please try reinstalling SQL Assistant. The last build is 1.0.47.

I remove SQL Assistant and reinstalled the latest version 1.047 with no difference. All targets (except Notepad) are selected on the target tab. But nothing works. I am in Query analyzer and if press CTRL Space or CTRL F1 or CTRL F5 nothing happens Its no different than before I installed the product.

Now when I go into Enterprise manager and try to create a job I get a pop up window from SQL Manager asking me to Log in. I pass the server name leaving the rest as default (windows authentication which is what I normally use) The pop up goes away, and the screen where I was writing the T_SQL code for the job greys out and the after a few minutes Enterprise Manager crashes (MMC abend) I tried this a couple of times with the same results.

A further update... AI think I know what my previous issue with Query Analyzer relates to. I very rarely open Query Analyzer from the START, ALL Programs... etc menu. If I do then SQL Assistant works. If I open up Enterprise Manager, then go to the TOOLS menu and select Query Analyzer it does not work.

I guess, I know what the issue then. Prior to built .049 SQL Assistant used case-sensitive program name options. So if you register “isqlw.exe” it would not work with “ISQLW.EXE” and you would need to register ISQLW.EXE as a separate target.

This has changed in the last build. The program name comparison is case-insensitive now.