Have you tried SQL profiler, I am sure it should tell you who logged in and changed it, there should be an option in there that tells you who was...

yep people in England need to stop paying to subsidizer's the rest of the world including the usa, we have two of the biggest fuel companies in the world in...

cool sounds good, hehe when I lived in London, I lived in oval, what a crap whole that was but very handy to London, and cheap I could walk most...

sorry hehe it takes 1hr and 6min to London waterloo, that is still quicker, I just checked out nationalrail.co.uk I still knew it was quicker. cost is 12:80 for the...

so long big a, you did know he was a pedo thought thats why he went to live in lanker. 😉

well people from england if you really want to see the English don't go to london, there are no English there now, you are likely to get stabbed rather than...

depends on who I talk too if I talk to a technical person I would say sequel, to a person who knows nothing I say ms-sql or sybase sql...

yep I could afford all them things now I am married with 2 kids and the wife spends the money lol.

I live in Japan, I have to go everywhere by train, I live about 30k from tokyo, however, the land of the shinkansen, has really slow trains. in the uk...

sorry guys looks like I have sorted this one out on my own in the end. It was a problem with cached credentials, I had no choice but to restart...

it looks ok, I cant see why it would cause a deadlock, if it is look at the locking of your table.

T

Hi there best way is to

1) dbcc opentran(datbasename) - this will show the oldest open transaction

2) Kill this process

3) backup log Database name with no_log

4) use databases...

I would just create a basic NT account that has ad rights and then add them to the sql server users with the rights of process administrators role, if they...

yes this will not stop deadlocks on its own there are a number of things you must do, look at the table and how they are set-up the code you...

cheers guys I have sorted it out, i changed the restore times to 30 mins and it seems to be working again, fingers crossed it does not break again or...