I assume you know which login dropped/created the procs.

and assuming you are a SYSADMIN what output do you get out of these

execute as login = 'loginname'

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

use...

yup it was...

count the brackets

don't waste time with small changes that will have minor impact on the process.

Do worry about trying to put on paper what the process should do to a whole set,...

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

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...