@@servername problem

  • Name of the server had been changed recently. After change I executed sp_dropserver and sp_addserver. If i select * from sysservers new server name comes up, but if I run @@servername old server name shows.

    Can anyone help?

    Thank you

  • I think you have to restart the service to correct that problem!!  Wait for a confirmation before doing so (unless the server is not in production)... I ain't 100% sure on that one.

  • Yes, you must restart SQL Server to see the name change.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply