I connected to a remote db (192.xxx.xxx.xxx) vua VPN and added that db in my local studio environment. I know how to connect to a different db...
select from testdb.dbo.test_table (etc)
My code to select from the remote db is:
select * from [192.xxx.xxx.xxx]..testdb.dbo.test_table
Is stating I have too many prefixes. I know this is simple but short on time and would apprciate any help on this.