There are those rare times when you have a need to rename your server that is running SLQ server on it. You may now know that once you change your server name.. that connecting to the SQL portion won’t work particulairly from remote clients. I have found a couple of pretty simple SQL commands that can help assist in this. From Query window.. I typically set it to “Master”.. run the following commands. To return current name – SELECT @@SERVERNAME AS […]
