soon hopefully we will upgrade, and we can experience 10 year old Tech 🙂

cheers Gila for advise! always appreciated

hi Gila

so the db is currently in restoring mode as you would expect, as soon as i take it out of this mode, wont i have to do...

apols, i really have posted a bad question in a rush

ill be back with a revised post

Sue

i went back to basics, i think the person who originally installed sql made a bit of a mess of things, but an uninstall and a reinstall with...

hi Sue

no other file types here - all .log
this is also the sql server with report server dbs etc
nothing of much interest in the event...

Cheers sue, never even thought of srs event log !

But have tried ie admin already, with same result

hi Gail

if i was able to change the code what would you recommend (on the off change i can get the mod made)

thanks for help, its...

hi Gail

no, ill not be able to change the code unfortunatly

mal

hi Des

its a vendor app, on old software they probably have fixed in a latest version, but we cant move to the latest version..

we will be...

USE [SysproCompanyW]
GO

/****** Object: Index [SalBranchKey]  Script Date: 17/04/2017 09:41:33 ******/
ALTER TABLE [dbo].[SalBranch] ADD CONSTRAINT [SalBranchKey] PRIMARY KEY CLUSTERED
(
    [Branch] ASC
)WITH (PAD_INDEX...

wouldnt let me upload .xdl

but this is the txt

<deadlock victim="process26033d38"><process-list><process id="process26033d38" taskpriority="0" logused="0" waitresource="KEY: 17:72057655109550080 (61001edaa25e)" waittime="156" ownerId="1733094732" transactionname="implicit_transaction" lasttranstarted="2017-04-13T15:34:45.533" XDES="0x210e38d0" lockMode="X" schedulerid="1" kpid="11544" status="suspended" spid="165"...