Which CRM system do you use?

You can start a job automatically when SQL Server Agent starts.

In order to run extended stored procedure xp_regenumvalue, SQL Server has to load 'xpstar.dll' first because this xp is one of the module of 'xpstar.dll' but SQL Server launches startup procedure before...

It looks like you want data insert/update in Oracle database be insert/update in SQL server at same time. You have to setup linked server and run distributed transation to insert/update on...

varchar works fine.

Contact Microsoft PSS and send the dump files to them for investigation.

I am not aware of that. Sorry.

select DATABASEPROPERTYEX( yourdb , 'Recovery')

What is the query time-out setting in your QA/EM? Verify it from EM --> Tools --> Options --> Advanced tab --> Query Time-out.

You have to perform extensive test before you know the impact to your database and application.

We have seen performance decrease largely after applied sp3a to our very busy SQL Server...

If the query does the order by with the order different than the order of columns in existing index, the query could run into table scan.

As suggested, you should examine the...

Can you ping to the server with server name and Have you tried to connect with ip address from your machine?

Check MDAC version on your machine. Try to upgrade it to...

How do you perform the simple insert? Do you receive time-out from QA or EM when perform similar insert? Can you post exact error message when time-out occurs?

Can you post hardware configuration...

Which version of SQL Server do you run, standare or Enterprise?

1.  Not one table has a primary key or clustered index

It is not necessary each table must have primary key or...

Are these five machines identical in hardware and configuration? Do you run database statistics update after the restoration?