Hi,

You can iclude it in the script to kill the SPIDs connected to the database and keep database in sigle user mode to avoid any new connections and then perform...

Hi,

The issue need not be related to only a job failure. As the SQL Server Agent is responsible for other tasks as well (schedules, alerts etc.,). However, the problem could...

Hi,

As far as I know, the Use can't be given directly inside the procedure as a statement. But, you can try this.

DECLARE @alert_str varchar(25)

SET @alert_str = 'use '...

Is this a constant problem or does this happen only during certain time or is it kind of intermttent issue faced?

Certain basic things you can check are:

If there are any...

May be you can check these two options first:

1. The TEMPDB might have been configured with some Maximum Size and your transaction needs more than the configured space.

2. Though Unrestricted...

Not through the job history, but from the maintanace plan history (Right click on the maintanance plan)...we can get the details for each database which is a part of maintenance...

I guess you can use @@rowcount variable to get the count. It holds the count of rows affected by the last statement.

Renuka__

The error message contains either error code or some kind of description based on which it can be analysed why did the job fail. The reasons can be many...... You...

The task of the DTS shows as failed. If you have set up any file to capture the error details (Steps tab-->Advanced options), you can see more info on the...

Yes. The MSDB and Model DB needs to be restored from the back ups.

Renuka__

First you may do the basic checks like...if there are any blocks being created during the procedure execution OR if there is any job running at the same time....

Renuka__

Hi,

You can use "On Completion", which goes to the next task irrespective of the status (success/failure ) of the preveious task.

Renuka__

Hi,

There might be another (rogue) log reader process running which needs to be terminated. May be you can check for that and kill it and see if it helps.

Renuka__

Hi,

To make it even easier, just right click on the DTS package ans select "schedule package" and schedule it. A job will be created with the same name as the...

Hi,

If I have understood your requirement correctly, this should work:

Under the destination tab of data transformation task, the connection shows " , below that it says "Table Name", there I...