"sql prompt cannot retrieve objects from ."
This is the second time I got burned by this error. For some reason my Target Connection String got cleared in Visual Studio and started causing this error. Luckily, I looked at my previous posts here. For anyone else getting this, the solution can be found here:
http://stackoverflow.com/questions/1448 ... -sql-proje
If SQL Prompt depends on this setting in Visual Studio to work correctly, shouldn't it prompt for this if it is not set instead of giving an error? Or at the very least, can we get SQL Prompt to give an error message that is more descriptive instead of just passing back what it got from SQL? I had to spend too much time tracking this solution down again.