Installing SQL Server Instances
A SQL Server instance is a completely independent installation of the SQL Server engine and its related services, such as SQL Agent. There are two types of SQL Server instances: default and named. A default instance is identified by the name of the server where it runs, whereas named instances are identified by the server name and the instance name (servername\instancename). There can be just one default instance running in a server, and it works exactly as previous versions of SQL Server. Regarding named instances, you can install as many named instances as you want in a specific server, even if there isn't a default instance installed. However, Microsoft supports only a maximum of 16 named instances per machine. ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
