actually you have 3 questions ;)
1) Just install the server and the client connections. Don't install the Books Online on the server. 2) SQL Server is fully ANSI 92 compliant. you shouldn't have a problem except if you used certain functions that are supported in PostgresSQL and not SQL Server. 3) The Book Online is the best for SQL server. you could probably find 95% of your answers there. If you can't find your answer there, hit groups.google.com. MS also has a SQL Server section www.microsoft.com/sql Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 4:16 PM To: CF-Talk Subject: SQL Server Install and CF Just sold our first CF app... a large manufacturing system. It is based on our previous client server mfg systems. The Installation environment is Windows 2000, SQL Server 2000, and CF5. Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. Two Questions: 1. Was wondering if anybody has any sage advice about how we install SQL Server. We have never installed or used it but have been told that there are several options we might want to select when we install. 2. Since we were careful to use Generic SQL queries (ANSI 92) we think that it should run with few adjustments to the code. Is that reasonable? 3. What might be considered great source material for learning more about SQL Server? ok, three questions ;) thanks guys, Brian ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
