Change your on error to redirect row and output the data to a file. Then you can examine the data that is being rejected by the conversion and determine...

It looks like you are using a query across a linked server to the DB2 database in the Execute SQL Task. If this is true can you execute the...

There is not a database level setting for this. You can only enable the new Row Versioning Isolation Levels at the DB level using:

ALTER DATABASE DB_NAME

...

Without seeing some kind of code it is nearly impossible to figure out what is wrong other than asking, Are you sure actually altered the SP? If you did...

Why use SQL Mail instead of the new Database Mail feature? With Database Mail you should need an SMTP Server to point to.

The best way to improve performance of a query is to examine the Execution plan, Statistics (Set statistic IO on) and tune the query based on this information. Execution...

You should run...

Lynn,

Attached is a Word Doc with screen shots of my Alert.

Here is the Alert scripted by SSMS:

USE [msdb]

GO

/****** Object: Alert [Test] Script Date: 04/04/2008...

Could you post some schema info so we can be little clearer on what you want?

You can certainly do:

Update TableA

Set columnA = 1

Where

...

What is the data source you are connecting to? There could be settings that need to be made on the source or on the connection based on the source.

Sorry I presented a SQL 2005 solution. B's solution should wotk in 2000. The INFORMATION_SCHEMA views I mention are available in 2000 though.

This query gets you dependencies:

Select

D.id as main_object_id,

O.name as main_object_name,

O.type_desc as main_object_type,

depid as depends_on_object_id,

DO.name as depends_on_object_name,

DO.type_desc as depends_on_object_type

from

sys.sysdepends D Join

sys.all_objects O On

D.id...

I would work under the assumption that it is not a an RS permissions issue unless the Cannot Display message specifies because the user does not have rights.

You should be...

I would wonder if it was adding a column or changing the Not Null to allow nulls that caused the issue?

For some reason I cannot see the image you have embedded. Could you try attaching it?

Are the 4 inputs all columns in a table or are will they be...