It sounds like your query runs in parallel. You should see whether it runs in parallel from the execution plan. You could also set "max degree of parallelism" to 1...

MSDE is the mini version of SQL Server and the stored procedure created in server version will be run in MSDE without any changes. Be aware of the capacity limitation...

Remote servers are set up in pairs. To set up a pair of remote servers, configure both servers to recognize each other as remote servers. Then, verify that configuration options...

Can you post more details error messages?

Depending on the database recovery mode. If it is 'simple', you can backup log with truncate_only and dbcc shrinkfile. If database is in 'Full Recovery' mode, you should backup the...

SELECT DATABASEPROPERTYEX('yourdbname', 'Recovery')

Check Microsoft Baseline Security Analyzer v1.1.1 at http://www.microsoft.com/downloads/details.aspx?FamilyID=9a88e63b-92e3-4f97-80e7-8bc9ff836742&DisplayLang=en

The latest service pack is sp3a and security patch is ms03-031.

select @@servername

select select system_user

Do both servers have same service pack and MDAC version?

Which patch do yo refer to? If you talk about SQL Server patch, The patch installation will affect only the instance you want to applied. You may have to reboot...

Check your machine application and system logs. You may have some kind of hardware issues with the RAID disks.

Dependin on which service pack do you have in these workstation running MSDE? You may have to block TCP port 1433 in your firewall.

I would break the update into small batches , loop it and print the status at end of each batch.

Did you remove 'BUILTIN\Administrators' from SQL Server Logins? If you are, you have to grant 'NT Authority\System' to access SQL Server with 'sa' right.

Use SET IDENTITY_INSERT to allow explicit values to be inserted into the identity column of a table.