Aliases defined with Client Network Utility (SQL Server 2000) can have spaces, but SQL Prompt stops at the first space.
For example, if I define an IP address '1.2.3.4' to have the alias 'Star Trek', I can connect with query analyzer to a sql server called 'Star Trek'. The authentication prompt from sql prompt 2 will default to connect to a server called 'star'
For example, if I define an IP address '1.2.3.4' to have the alias 'Star Trek', I can connect with query analyzer to a sql server called 'Star Trek'. The authentication prompt from sql prompt 2 will default to connect to a server called 'star'