and please please replace all those selects from tblIssuedTrack onto a outer apply and do the aggregations within it so you only access the table once

Good - but do remember that in order to use a tool you need to learn how to use it - if you are like this with a...

Thanks Federico , yet this seem to not work properly , at least as far as I cloud see:

 DECLARE @TimeStamp VARCHAR(50) = '0x00000003098F384E'
SELECT CONVERT(BINARY(8), @LastTimeStamp,1)...

Regarding the kerberos delegation - you may have misunderstood it.

Imagine the following scenario

User (PC) -> SQL Server -> stored proc writes to file on File Server -> File Server

in order...

you need to look at what each of the procs is doing and determine what really needs to be done and what is not really required - most of the...

he...

FYI made changes in the import wizard and the data imported just fine. I do suggest that when you post a problem, whether here or another site, that...

if you had to create the spn's I would advise restarting the service.

load into a staging table

do joins to main target table - if existing record update, if new record insert . (do updates first)

even if you are using SSIS to do...

are you using SSMS on your own PC to do this or rdping to the server and using the SSMS on each individual server?

if on the server then the issue...

it is highly likely that its one (or both) of 2 things

1 - server does not have required SPN's and is not authorized to delegate your credentials. (google for kerberos...

how are you exporting the data?

and where/how are you opening those files?

line returns on a valid csv file are not a problem it the software reading that file correctly handles...

Thanks Steve

Same - its only when I wish to look at an old message that I go there - today decided to go in to see if I had any message...

from my previous post "what is the performance issue you are getting (is it locks? dead locks? plain slowness?)"