You can set a DSN to use any instance you have installed, you simply name it in the DSN.
-----Original Message----- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 12:20 To: CF-Talk Subject: SQL Server Instances and CF 7 I have a database that multiple sites are going to use and contains a substantial amount of data. Is there any way in SQL server you can make an instance of the database and allow different sites to hit the different instances keeping the sqlserver.exe from taking up too much cpu and memory? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
