Two Instances Of SQL Server???

[AmbiguousName]

Hello guys...im new to database administration. What does it mean when we say that we are running two instances of SQL Sever on my computer?? Does this mean, installng sql server two times with different serial numbers??

[David Mujica]

You can install SQL server more than one time on a computer. Maybe this article will help you ... http://msdn.microsoft.com/en-us/library/ms143531.aspx[^]

[AmbiguousName]

thanx buddy....

[debrah h48]

Microsoft® SQL Server™ 2000 supports multiple instances of the SQL Server database engine running concurrently on the same computer. Each instance of the SQL Server database engine has its own set of system and user databases that are not shared between instances. Applications can connect to each SQL Server database engine instance on a computer in much the same way they connect to SQL Server database engines running on different computers. For more information about this visit http://msdn.microsoft.com/en-us/library/aa174516%28SQL.80%29.aspx[

[Mycroft Holmes]

Why point to a version 2 releases back? Your link really screwed up the formatting :-D

Never underestimate the power of human stupidity RAH