You can't use @@servername or run any other query. Running a query requires you connect to a server. You have to know what server you are connecting to. That's the...

(local) won't work if multiple instances are installed and you want to connect to other than the default instance...