by reading the error message it looks like the "SQL Agent" service is not running. If it is running, then probably the account used for the SQL Agent has not...

You forgot to add the time to the filename. The CONVERT(VarChar(20),GetDate(),112) give you a date in notation in format yyyymmdd. You have to add the time to this part to...

From BOL (under ALTER DATABASE):

Moving a file to a new location

The following example moves the Test1dat2 file to a new directory.

Note:

You must physically move the file to...

IIF is a function available in Microsoft Access database and not in a SQL database. You have to use CASE instead.

Sample from BOL:

SELECT ShipVia, CASE ShipVia

...

For my knowledge it is possible for Database Mail to recieve e-mail. You have to re-route the mail address from Database Mail to your own.

Are all logins you see with sp_who2 your own? If not, other users are accessing the database. Kill those connections and try again.

Try and 'SLIPSTREAM' the SP2 installation file on to the SQL installation files. This will create new installation files for SQL with SP2 included.

There are many websites providing a step-by-step...

When you create and send a test-mail, do you recieve this mail?

Try following the steps provided in the topic "Troubleshoot Database Mail" in BOL.

This code is a VB Script file that will read a folder and add the text of each file to a new (combined) file. The combined file can be executed...

ananda.murugesan (10/12/2008)

---

i want script itself how to attach at @messagefile backup report text file automatically from particular disk path,

For example - @messagefile = N' C:\dbbackup\filename.txt', this file name has...

Try changing the notation of the date.

Instead of

use CAST('20081008 12:01PM' AS DATETIME)

You should also check if the local settings of the machine are...

After closing all applications, you have to look for running processes. It sure looks like you have an application running on the background (or hidden). If the failing logins also...

Try removing the dashes from the value in variable @WeekEnding:

Set @WeekEnding = '20080101'

This is the general notation of dates as a string that will convert to correct datetime values.

And what...

Keep in mind that if the table has a clustered index, the column or columns defined in the clustered index are automatically appended to the end of each nonclustered index...

chad (10/1/2008)

---

There are 3 non-clustered indexes on this table. One on the Date Entered column, another on a integer ID column, and the last on both the Date Entered...