While working on remote server, we donot get auto complete feature on any sql server version. It will very difficult to write sql query.

But there are some alternate approach to implement autocomplete on sql server using sql server extestion like sql complete and Apex Sql Complete

Sql complete download link

Apex sql complete download Link

This tools really cool and handy for developer who is writing the sql query every day.