Code differentiating between SQL Server 2000 and SQL Server 2005
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 30, 2008 7:28 PM
UPDATED:
July 2, 2008 6:46 AM
RELATED QUESTIONS
- differences between SQL server 2000 & SQL server 2005
- i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
- Trouble installing SQL Server 2005
- What are basic differences between SQL Server 2000 and 2005?
- Running SQL Server 2000 and 2005 simultaneously
Answer Wiki:
The instance would need to have a different name. If you install SQL 2005 on the same server that already has SQL 2000 installed and you use the same instance the instance will be upgraded from SQL 2000 to SQL 2005.
Within your connection string where you specify the server name you specify the instance name as well.
<pre>Default Instance: SERVERNAME
Named Instance: SERVERNAMEINSTANCE_NAME</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.