Select @@ServerName not returning anything

Question

Post reply

Select @@ServerName not returning anything

Alan RAczek

SSC Enthusiast

Points: 146
More actions
July 12, 2010 at 7:10 am

#139778

Okay, I know it's a Monday and I have done this before but I can't get the command
Select @@ServerName to return anything. Just gives me "Comand(s) completed successfully.
I have done this before and it has worked I don't know what I am missing.
I would type:
Select @@ServerName
--> Usually I get the SQL instance name in the query results, but just get
Comand(s) completed successfully

Viewing 7 posts - 1 through 6 (of 6 total)

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

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

Should work. . .

What happens if you do

PRINT @@ServerName

?

Also, check

SELECT *

FROM MASTER..sysservers

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Alan RAczek SSC Enthusiast Points: 146 More actions · Answer 2

Same thing, Command(s) completed successfully. Essentially I am writing a procedure to change the SQL name as we use images of systems to deploy to developers and SQL is pre-installed. Machine always gets renamed when deployed. As I said I did this before no problem and it's p_____g me off. Just don't get it.

Cadavre SSC-Forever Points: 41690 More actions · Answer 3

I don't want to sound rude, so don't take this the wrong way please 🙂

It sounds like you're parsing the query instead of executing.

Try pressing "F5" to execute, or go to Query heading, then down to Execute.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Alan RAczek SSC Enthusiast Points: 146 More actions · Answer 4

Okay, my bad. I was clicking the green check mark instead of 'Execute'. Finally remembered.

Doh!

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 5

If your SQL server is hosted on a VM, u are likely to get a wrong Server Name using @@ServerName.. Use OBJECTPROPERTY() function instead..

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

As coldcoffee suggested, use of ObjectProperty is a good reliable source too!

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events