Please refer this link for getting started.

If you already have Database Mail configured, please check the properties of the same. It will contain the SMTP server details.

You may use ' ' or CHAR(32) to include spaces as in the below example.

select ' ' + 'Name'

select char(32)+char(32)+'Name'

Use TRY...CATCH to catch exceptions. Here is the documentation.

Here is the official documentation of that function.

You may move the user databases using Detach and Attach method. Detach the database, move the files to new the drive using explorer and attach database. You can do it...

You may use RESTORE FILELISTONLY as in the below example.

RESTORE FILELISTONLY FROM DISK='E:\MyBackup.bak'

You may use something like this

select right(left('Microsoft SQL Server 2008',28),4)

ejbatu1 (8/5/2010)

I have a SQL 2005 DB that the log file (LDF) is growing too large (over 25GB). The Autogrowth is set to: File Growth in 10% and Maximum...

You may want to enable logging to the package as explained here and check those error messages.

You may find these links useful.

http://msdn.microsoft.com/en-us/library/ms160334.aspx

http://technet.microsoft.com/en-us/library/ms345234.aspx

You don't configure MAX MEMORY using AWE,...

I would suggest re-installing SP2 only for Client Components. Please take care not to select "Database Services" and other components.

Even if you configure AWE, it will be ignored in 64 bit environment.

I don't see the word CASE in the entire code. Am I missing something here?