tag:blogger.com,1999:blog-8456291897050186888.post6519051232461083218..comments2010-02-14T21:25:01.982-05:00Comments on Me & My Little Techie.......: Getting the Server Name in SQL Server using @@SER...Vijaya Kadiyalahttp://www.blogger.com/profile/08108155552780950397noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8456291897050186888.post-29366412729080215852010-02-14T21:25:01.982-05:002010-02-14T21:25:01.982-05:00Hi vijay,
Just wanted to add something to your po...Hi vijay,<br /><br />Just wanted to add something to your post. If servername is changed then @@servername still points to the oldname. Updated name can be found by Serverproperty('Servername').<br /><br />Updated servername will reflect on sql server after one does sp_dropserver and then continue with sp_addserver 'newname','local' and then perform a service restart.<br /><br />You may be aware of these. Just wanted to add to ur post. :)<br /><br />Regards,<br />RajNagaraj Venkatesanhttp://www.blogger.com/profile/17134038987463298279noreply@blogger.com