Using 2008 R2 SSMS, I am connecting to a 2005 database by IP address over a VPN connection. I am able to connect and browse the database; however, when I try to query any tables I receive no results.
If I right-click a table and select top 1000, the results are displayed. When I copy that same query into a new query window, I receive 'Query executed successfully' in the lower left, but no results pane.
I am also seeing 'query completed with errors', but no messages in the messages pane.
This is strange behavior as I've used SSMS 2008 to work with 2005 and 2000 databases in the past.
Thanks for your help.
Steve