How to configure SQL Server to use more than 2 GB of physical memory

http://support.microsoft.com/kb/274750

AWE Memory SQL Server Performance Tuning

http://www.sql-server-performance.com/awe_memory.asp

Check "SQL server Client Network Utility" alias tab...if you have entry in that you get more than one names retrurned for the same instance...

Is source and destination table has the same schema?

http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

http://msdn2.microsoft.com/en-us/library/ms175905.aspx

CREATE INDEX Employee_Ind ON Employee(LName,FName,Minit) WITH

Is your snapshot location is shared? Try to use UNC name for snapshot..

From BOL: An index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF.

Issue the command with ALLOW_PAGE_LOCKS ON

Did you change the outlook as default mail client in your IE?

How to change your default e-mail client in Outlook

http://support.microsoft.com/kb/196257/en-us?spid=2520&sid=global

How can I configure Outlook

to...

I don't think there is any column which gives this info...

But if auto update stats is not enabled on your db then you can use the following script to get...

What is the data type for "item" column?

Try using DTS.

How to pass a list of values or array to SQL Server stored procedure?http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

How do I simulate an array inside a stored procedure?http://databases.aspfaq.com/database/how-do-i-simulate-an-array-inside-a-stored-procedure.html

I agree with Lynn...

SQL server 2005 has good options... you can find easlily unsed indexes and required indexes too...

http://www.sqlservercentral.com/columnists/aingold/2770.asp

Good luck...

I agree with Declan For SOX you have to use auditing products...

We are using Lumigent Entegra... It is not that good but all are these products are new so it...

Are those named instances? If yes try using port number along with instance name... also try connecting to the linked server from the source server using QA...