|
Question: Do you
have a sample of the proper setting for MS SQL Server 2005 & 2008?
Answer:
SQL Server 2005 and 2008 include several
properties that were not accessible in previous versions. Below
are screen shots reflecting the recommended SQL Server Properties.
In addition, the Database compatibility mode should be set to 80, see
screen shot below. You will need to download and install the SQL
Server Management Studio Express program to perform these tasks.
Click here to download.
The ExpressMaintenance database should
have a compatibility mode setting of 80 as shown below.
The ExpressMaintenance database should
have etuser as the authorized user with full access.
 |
