I will change my question:

do SQL Agent initialize a transaction for each step although I don't initialize a transaction in the code of the step?

Thanks.

---- AL DTS dbo SSISCopiaTablasPrecarga AL PR IPA usp_CreaBD

alter procedure IPA.usp_CreaBD (@ServidorOrigen nvarchar(128),@BDOrigen nvarchar(128),@UsuarioOrigen nvarchar(128),@ClaveOrigen nvarchar(128),@ServidorDestino nvarchar(128),@BDDestino nvarchar(128),@UsuarioDestino nvarchar(128),@ClaveDestino nvarchar(128),@ServidorPaquete nvarchar(128),@BDPaquete nvarchar(128),@UsuarioPaquete nvarchar(128),@ClavePaquete nvarchar(128),@CorreoRemite nvarchar(128) = null,@CorreoDestino nvarchar(128) = null,@ServidorCorreo...

why need you to see the data?

I understand, but the column is nvarchar(max) with text.

I don't know how to put the data in the post. I know to put, but...

GilaMonster:

CREATE TABLE [IPA].[BDVersion](

[PkBDVersion] [int] NOT NULL,

[PkNumeroLote] [int] NOT NULL,

[PkNumMicroLote] [int] NOT NULL,

[AccionLote] [nvarchar](2) NOT NULL,

[TipoObjetoLote] [nvarchar](3) NOT NULL,

[EsquemaObjeto] [nvarchar](5) NOT NULL,

[Objeto] [nvarchar](128) NOT NULL,

[AccionMicroLote] [nvarchar](2) NOT NULL,

[TipoObjetoMicroLote] [nvarchar](3) NOT NULL,

[EsquemaObjetoML]...

Yes, both tables are equals.

The select:

select pknummicrolote

from IPA.bdversion

where codigo like '%CreaBD%'

Hello.

I have a machine with sqlserver2008 developer edition with sp1, and i have other machine with enterprise edition with sp1.

The BD's have the same table with the same information.

In developer...

I will wait for SQLserver 2008.

Thanks for all.

Hi Yelena, thanks for you answer.

In my example the table have only one row. But it is an example.

In a table with rows, i need to use the clause where.

The...