YES you must need a mail client.

You can configure the SQLmail in a clustered environment, but its not stable. You cannot guarantee the availability. MS says SQL Mail is not fully Functional on a Cluster due...

NO you can't restore just the data from a backup file. It's good practice to shrink the log file before you take the backup

DBArtisan, Spot Light and Patrol

What do you mean by virtual log?

Check the ODBC Connectivity to the SQL Server from the desktop you are connecting to

We have around 50+ SQL Servers and equal number of Oracle. Only two DBAs in our group knows both..I am still in the learning stage

-- Clustering is too expensive and you must need either Advance server or Data center unless you use some third party tools to setup the cluster ...

I prefer to do UPDATE STATS and recompile the stored procs with sp_recompile after the index rebuild

MS KB Says

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885

I agree with Allen

Also most of the Tempdb issues like this were fixed in SP3, but strange you already have SP3

http://support.microsoft.com/default.aspx?scid=kb;en-us;278363

http://support.microsoft.com/default.aspx?scid=kb;en-us;278366

CREATE TABLE #Errors (vchMessage varchar(8000), ID int)

INSERT #Errors EXEC xp_readerrorlog

SELECT vchMessage FROM #Errors where ID = 1

Drop table #Errors

What do you mean by the new server doesn’t recognize? Is the database on line in the EM after restoring on the new server? Or the restore it self is...

It doesn’t mater what service pack is on it. Is both servers are in the same domain? What’s your OS? Any clustering between the server?

Missing a point, When you double click on the application icon on the desktop, it should open the application and connect to the server with out entering the user/pwd, meaning...