Hi,

We decided to insert the info using

BEGIN TRANSACTION

INSERT INTO DB2.dbo.Table

SELECT *

FROM DB1.dbo.Table

WHERE CodigoCaso < @cont and CodigoCaso > @ultimo

SET @ultimo = @cont

SET @cont = @cont + 1000

COMMIT TRANSACTION

In order to...

Hi,

In the past I had problems with BCP because when I try to copy the data to a file some times SQL introduce returns between the data and when I...

Hi,

They are on the same SAN. Thanks

Hi,

The database is in Simple Mode.

Thanks

Hi, I need to insert it into a database. Thanks

Hi,

Thanks for your help in effect I solved my problem giving the proxy user the corrects access to the sql server ->

use [WIWBancolombia]

GO

GRANT SELECT ON [dbo].[Caso] TO [PARIS-SQL2005\csalazar]

GO

Taking into account...

DECLARE @Fecha DATETIME --MM/DD/YYYY

DECLARE @Resultado VARCHAR(100)

DECLARE @ResultadoCasos BIGINT

DECLARE @ImagenBackup XML

--Establecer los casos que se guardaran

SET @ImagenBackup = ''

--

SET @Resultado = 'No existen casos con esta fecha';

SET @Fecha = getdate()

--Casos...

When I,

use a normal user i got this error ->

Error = [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.

But when i use...