SELECT @@ServerName returns NULL

Question

SELECT @@ServerName returns NULL

Viewing 3 posts - 16 through 17 (of 17 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Read this:

https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SP_ADDSERVER_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true

Chris.Hubbard4U Ten Centuries Points: 1020 More actions · Answer 2

Lynn Pettis (8/17/2015)
Read this:
https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SP_ADDSERVER_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true

I regret that I did not answer your questions.

It is a default instance and the command returns NULL.

Thanks for the link.:-)

PurpleLady SSCertifiable Points: 7819 More actions · Answer 3

Any hotfixes or patches installed recently? Try

sp_dropserver 'servername'

sp_addserver 'servername', local

and restarting.