Thanks and regards, Jack.

JMSM 😉

Thanks a lot.

Regards,

JMSM 😉

Thanks a lot everybody.

I've used the following statement on insert

SET ANSI_WARNINGS OFF

insert into TraceResults(TextData, Duration, Reads, Writes, CPU, StartTime, LoginName, NTUserName)

select TextData, Duration/1000, Reads, Writes, CPU, StartTime, LoginName, NTUserName

from fn_trace_gettable('D:\Traces\Troubleshoot-TRACES.trc',1)

SET...

Gail,

I appreciate a lot all your posts and all information where you act as principal focus.

As i told you a lot of times ....... hope one day be so useful...

Thanks Gilla.

Regards,

JMSM 😉

Hello again,

Sorry for my interpretation.

The part of the code that i've gotting problems its exacly where i tried to use the ltrim(rtrim()) but i'm not getting what else can i...

Hello again,

I apreciate a lot the link that you send me but my part of this execution is the one that sends information to a .csv file.

Then client will...

Thanks a lot everybody.

The problem was that the network admin team gives me an ip address that was out of range..

:blink:

Thanks and regards,

JMSM 🙂

Hello again,

Thanks a lot but i've droped the database and backup admins will restart a new restore.

Before i've droped the database i run the following command to recover the tlog...

Thanks a lot everybody

I've already the command and database stays in the same state.

I think that i should ask for the Backup Administrators to start the restore again.

RESTORE DATABASE <db...

Thanks a lot.

I'll look you're post and after i'll tell u something.

Once more, thanks a lot,

Regards,

JMSM 😉

Thanks Gift

But when you tell me

'Make sure the data type for the columns is Nvarchar because in 2008 the bytes are the same with UTF16'

What do you mean with...

Thanks a lot everybody.

Regards,

JMSM 😉

Thanks.

Regards,

JMSM 😉

Hello,

Thanks .. .. thanks and thanks again Michael.

You've been very useful to me hope one day i can be useful to all of the members of this fantastic forum as...