August 14, 2015 at 11:51 am
Where I execute the command SELECT @@ServerName it returns NULL?
This just started today.
What could cause that?
August 14, 2015 at 12:45 pm
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does SELECT SERVERPROPERTY ( 'InstanceName' ) return?
😎
August 14, 2015 at 2:56 pm
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
August 14, 2015 at 3:53 pm
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
Are you connected to any server while executing this (joke, sorry couldn't help it:-D )
😎
Any changes you know of in the environment?
August 17, 2015 at 12:37 pm
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
Are you connected to any server while executing this (joke, sorry couldn't help it:-D )
😎
Any changes you know of in the environment?
No changes. LOL
August 17, 2015 at 1:03 pm
What does this return:
select * from sys.servers;
August 17, 2015 at 1:08 pm
Lynn Pettis (8/17/2015)
What does this return:select * from sys.servers;
It does not return any rows:unsure:
August 17, 2015 at 1:15 pm
Two questions:
1) is this a default instance
2) What does the following return: select SERVERPROPERTY('machinename');
August 17, 2015 at 1:31 pm
SQL Server got converted to NoSQL? :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 1:32 pm
Looks like someone ran sp_dropserver.
August 17, 2015 at 1:36 pm
August 17, 2015 at 1:36 pm
Lynn Pettis (8/17/2015)
Looks like someone ran sp_dropserver.
oops! I'd run too after dropping the server. :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 1:39 pm
Eirikur Eiriksson (8/17/2015)
Lynn Pettis (8/17/2015)
Looks like someone ran sp_dropserver.Someone should then run sp_addserver
😎
Yes. Need the answers to the two questions I asked.
August 17, 2015 at 2:07 pm
Lynn Pettis (8/17/2015)
Two questions:1) is this a default instance
2) What does the following return: select SERVERPROPERTY('machinename');
I did not answer you first question; sorry about that.
I can not think of anyone that EXEC the sp_dropserver command.:unsure:
August 17, 2015 at 2:12 pm
Chris.Hubbard4U (8/17/2015)
Lynn Pettis (8/17/2015)
Two questions:1) is this a default instance
2) What does the following return: select SERVERPROPERTY('machinename');
I did not answer you first question; sorry about that.
I can not think of anyone that EXEC the sp_dropserver command.:unsure:
I don't see an answer to either question.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply