Database can't be encrypted.

SQL Server encrypts :

• Login and application role passwords stored in SQL Server.
• Any data sent between the client and the server as network packets.
• Stored procedure definitions.
• User-defined...

One single update will tell you how many rows be affected in once.

sp_help yourtablename / sp_columns / sp_helpindex etc. See BOL for more commands.

What is MDAC version and SQL Server service pack?

If you have SQL Dump created, Send it to Microsoft.

It is Windows requirement.

See KB 312399 helps.

My mistake, Only sp2 need to istall ms02-061.

Try SQL Compare at http://www.red-gate.com.

If you install sp3 and haven't install hotfix ms03-031, you have to install security fix ms02-061, but you don't have to do that if you install sp3a. There are other...

What abot system resources usage like CPUs?

You can use the xp_regread undocumented extended stored procedure to read from the registry via Transact-SQL.

This is the syntax of the xp_regread:

EXECUTE xp_regread [@rootkey=]'rootkey',    ...

Check the registry.

uHKLM\Software\Microsoft\Microsoft SQL Server\<instance Name>\CurrentVersion\CSDversion

1. Any blocking occured?

2. How many sessions did you see duringthe insert? The Max sessions MSDE can support is only 8 sessions concurrectly.

From BOL.

"

Each transaction log file is divided logically into smaller segments called virtual log files. Virtual log files are the unit of truncation for the transaction log. When a virtual...

Check SET DATEFIRST  and SET DATEFORMAT  commands in BOL.

There is no server level configuration for datetime.