Run sp_configure 'max degree of parallelism ', 2 in your case to limit 2 processors to use in parallel plan execution at system level.

In order to get more dead lock...

Use xp_cmdshell to run DOS command "copy a.txt + b.txt c.txt" to create concatenate file c.txt and then run the DTS package.

Make sure there are no insert/delete/update activites to your user database during your test.

EXCEPTION_ACCESS_VIOLATION comes mostly from application bugs. I would send result of sqldiag.exe and the .dmp file to microsoft. You wouldn't be charged if it really is a bug.

I tested backup of "pubs" database with both maintenance plan and manually backup and both backup files have exactly same size.

The only possible cause I could think in your case...

Run this.

Select * from (

Select equipno,activitydate,activitytime from Table1

Union all

Select equipno,activitydate,activitytime from Table2

Union all

Select equipno,activitydate,activitytime from Table3

Union all

Select equipno,activitydate,activitytime from Table4

) as k Order by Activitydate desc ,activitytime desc

Check whether you have database optimization job scheduled to run prior the database backup job in maintenance plan.

Basically, there is no difference except you don't have to add parameters for login and password. For details, See BOL "dtsrun Utility".

You have to add bracket [] to your table name if you could do it in the wizard. For example.

select * from 31-01-2001 will failed but select * from [31-01-2001]...

What issues do you have after seeing memory is consumed by SQL Server? Any other applications run in same server?

SQL Server memory allocation has benn configured dynamically to use all...

What do you mean reboot SQL Server? Do you reboot the machine or just restart SQL Server?

You only need to restart SQL Server (SQL Server and Agent services).

Stop SQL...

Beath,

Your TEMPDB is too small in both data and log files. I would suggest to increase them to 200/100MB as starting and monitor the usage for later adjustment.

As John...

Have you tried to use /E parameter run packages under windows authentication?

There is no difference in restoration of database backup/transaction log backup between your original and new servers. You just need to restore database and logs with option "norecovery" untill...

Can you post the script that you used to create the view?