Have you performed a search in Google?

http://tinyurl.com/3dcv8r8

It can be annoying, try downloading the SQL Server 2005 Express Edition that includes the “Advanced Services” and simply don’t install them.

Backup/restore is my preferred method, making sure to also grab the MSDB database as it holds all of the maintenance plans and jobs.

Please do not cross post - please reference

http://www.sqlservercentral.com/Forums/Topic1107642-146-1.aspx

I may be a little confused on what exactly it is you are asking for, but Windows comes with ODBC built-in. Under Control Panel | Administrative Tools | Data...

This is beginning to sound more and more like an SMTP issue. Can you "white list" the SQL Server IP address on the mail server and try again?

As this is related to Great Plains, your companies accounting software, it would be in your best interest as their DBA to get this database in a full backup routine...

Is SQL Agent Started? Database Mail is sent out by SQL Agent

These errors are due to the fact that there is no available RAM to complete that current operation.

Take a look at the Windows Event Viewer for more information on this...

Hey Mark -

Take a look at the following site, it lists all build version numbers and links to download.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Thanks Gail, I forgot what forum I was in.

To see what changes may have been made, run sp_configure

Try using OPENQuery instead of Four-Part Query

I would suggest you take a thorough look at the SQL Server Surface Area Configuration for Features to see if any changes were made.

In a rush and managed to miss the all important Enterprise feature of "data compression." RTFS

Good question