Yeah thanks I tried that but it didnt seem to be sending the other user to the resource pool, this could be because the job in question runs under a...

A piece of code , not a stored procedure but kicked off by an app at wrong time of day and no idea how to turn off from app.

Could...

its a temporary solution to an unavoidable issue of blocking ....don't want to kill all sessions blocking just this one running this code. If anyone knows how to script it...

Ok thanks but if I knew how to do that I wouldn't be on here....maybe someone else has an idea. ...or there is a similar script out there I have...

• This reply was modified 3 years, 3 months ago by  caz100.

Ok thanks a lot, anyone any idea how to code the second part? To actually do the kill

And produce a kill script from that select.

I need to select all SIDs of a particular user who is running a particular piece of code, there in lies the challenge 😉

Thanks Jeffrey...no azure involved.

Either file system or msdb.

It's the siss part I am after the database and logins is straight forward.

Thanks for your responses. The internal report on top table size was sufficient for me

And to add....

Datafile of 50 gigs 40% free space and log file of 30 gigs 99% free.....so 5 gigs might be ok for backup ?

Ok is there anyway to predict the backup size so I  know if my (80 db size in db properties) with a 5 gigs backup without using compression is ok?

• Ok thanks ...I was starting to worry one of them one must be wrong.

Thanks can you explain the index = 1 or 0 please ? 

Thanks but nothing there is what I am after.

I need to know what was the total size of transaction log backups between datetime A and datetimeB.

This will give me an...