Per my dba's, MS/SQL service pack 3 prevents (but does not correct) the
corruption of the server name.  If its already corrupted, do the following:

>From sql analyzer:
        
   select @@servername

   sp_addserver 'New-Server-name',local
 
   bounce SQL Server
 
   check server name by select @@servername



On Thu, 30 Aug 2001, Zeeland, Martien van wrote:

> Hello Joel,
> 
> We've got also the same problem with our SQL severs that the GUI opens and
> closes again without doing anything.
> The server also returns the servername NULL with the select @@servername
> command.
> I saw on msgs.adsm.org that your solution was to change this servername into
> the proper server name.
> 
> My question to you is: 
> Where / how can i change this servername in SQL ??
> 
> 
> Thanks in advanced,
> 
> Regards,
> 
> Martien van Zeeland
> Prod. Coördinator
> EMI Compact Disc (Holland) BV
> martien.van.zeeland AT emimusic DOT com
> 
> 
> 
> ----------------------------------------------------------------------------
> 
> 
> 
> This e-mail including any attachments is confidential and may be legally
> privileged. If you have received it in error please advise the sender
> immediately by return email and then delete it from your system. The
> unauthorised use, distribution, copying or alteration of this email is
> strictly forbidden. If you need assistance please contact the IT help desk
> on +44 207 467 2154. 
> 
> This email is from a unit or subsidiary of EMI Group plc, registered in
> England No 229231 Registered Office: 4 Tenterden Street, London W1A 2AY 
>