tags:

views:

51

answers:

1

What is the recommended setup.ini for SQL 2000 MSDE install?

So far, I use:

[Options]
SAPWD=comp1exPa$$word
SECURITYMODE=SQL
INSTANCENAME=MSSQLSERVER
DATADIR ="C:\Databases"
COLLATION=SQL_Latin1_General_CP1_CI_AS
+1  A: 

This is good enough.

However, it would be better if you used SQL Server 2008 Express 10 years after the first release of SQL 2000 and 4 years after it's last service pack...

gbn