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.
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.