Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

@@servername returns NULL

Status
Not open for further replies.
holdahl

holdahl

IS-IT--Management
Apr 4, 2006
213
NO
I'm trying to run commdand select @@servername on one of our new ASE 15 servers.
The output says NULL.

Where do I define the @@servername?
I need to return the name of the db server.


-holdahl
 
Sort by date Sort by votes
add server type local using sp_addserver and then restart the dataserver.

select * from sysservers where srvclass=0
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tison
  • Locked
  • Question
OPTDIAG returns "cant get localized message"
Replies
0
Views
56
Tison
Tison
cch868
  • Locked
  • Question
Load database command returns incorrect syntax error
Replies
3
Views
83
sybaseguru
sybaseguru
varocho
  • Locked
  • Question
setting smalldatetime column to NULL
Replies
2
Views
50
varocho
varocho
babeo
  • Locked
  • Question
delete null records
Replies
2
Views
45
babeo
babeo
viper78
  • Locked
  • Question
IS NOT NULL not working in stored procedure when SET ANSINULL ON
Replies
0
Views
28
viper78
viper78

Part and Inventory Search

Sponsor

Back
Top