which one failed?

and did you do

execute as login = 'domainname\username'

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

i've used this with other windows groups only granted to sql and it works fine without the...

• This reply was modified 4 years, 1 month ago by frederico_fonseca.

size of the column

e.g. varchar(xxxx)

so do give the ddl as asked.

that death.location column is bigger than 1k bytes I would assume by the error.

but do give has the ddl for the 2 tables involved.

alongside what has already been suggested (plenty of it and with indication of what how you could/should approach the issue).

hire a rather good SQL Developer to do this for you.

placement of files on physical drives (same or separate) as well as being local or SAN (and type of SAN) as well as being SSD or SATA (and RAID setup)...

• This reply was modified 4 years, 1 month ago by frederico_fonseca.

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