Hello,

Please excuse my English.

I am trying to regiter a remote server from Enterprise Manager. The server I am trying to regster contains "hyphen" in the server name. I am following the example that MicroSoft suggested but still getting an error. Can anyone help?

Below is the script I ran and the error message I get.

the script:
set quoted_identifier on
exec sp_addserver 'MY-SERVER1'
set quoted_identifier off

the error message:
'MY-SERVER1' is not a valid name since it contains invalid characters.

Environment : SQL6.5 sp5a on NT4 sp6a

Regards,