Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I had to change the computer name from x to y on a sql server 2008 r2. And followed the instructions [http://msdn.microsoft.com/en-us/library/ms143799.aspx]

Now when I select @@servername it shows null.

However when I Query Select * from sys.servers, the new server name is listed..

@@Servername is used in many of stored procs..

share|improve this question

migrated from stackoverflow.com Sep 20 '10 at 4:31

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer

Well, the answer is that you have to specify 'local' when adding the server after deleting.. now it shows the server name

Here is the link.. http://techontip.wordpress.com/2010/01/05/rename-sql-server-2008-single-server-senario/

share|improve this answer
    
I'm glad you got it solved. You should choose this as the answer to your question. –  Jon Sep 17 '10 at 23:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.