1

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..

0

1 Answer 1

2

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/

1
  • I'm glad you got it solved. You should choose this as the answer to your question. Sep 17, 2010 at 23:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .