Data Dude

I can get SQL Assistant to work in Visual Studio, but when using Team for Database Professionals it only works when the file is not associated with a Schema Object. Is there a way to make this work?

That's because a different type of editor is used for object editing.

You need to modify target "Advanced..." options for VS. In SQL Assistant Options choose Targets, then select MS Visual Studio target then on the right hand side of the screen click Advanced then click the eclipse "..." button to expand Advanced options. Edit the "TargetWindowClass" option and add a comma following by the object editor window class. To find out object editor window class you need to use some kind of Window Spy utility. One is provided for example with the Visual Studio full edition.

Another way to get what you want is to press Ctrl+F5 hot key in VS while the cursor is in the object editor and when SQL Assistant's Target Options dialog will popup, choose T-SQL and other options for a new target and save new target with a different name, for example, "Visual Studio Object Editor." In this case you don't need to know the window class name.

Hope this helps.

Using Ctrl-F5 worked. The first time it told me it was an unsupport window class, but I tried it again and it worked.

This is a big plus and will make my life a lot easier. Your product is the only one I found that will allow me to do this. Most other programs like this one automatically picks up on the connection, but when working DB Pro you aren't actually connected and they won't work. This allows me to link SQL Assistant against my Sand Box to get my intellisense. You should actually post this all over Microsoft threads, because I am sure a lot people using DB Pro will want this.

Thanks

Thanks for nice words! We would be very grateful if you can recommend it to other people. You know when a post is made by a vendor it is considered as a solicitation.