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

Hi there, yes you can do it you will have to set the db to 2000 compatibility in 2005 and yes log shipping is available in 2000 that is where...

Yep this sounds like you will have to install SQLnative client for 2005.

Regards.

Terry

hey with your experience you would probably be better off doing all the Microsoft certs you can and maybe doing somesort of charted course lie the citp or bcs well...

yes you should be able to use it as you have already paid out for the upgrade. I would still check with MS on this call them to find out....

not sure if you answered this question but this saves me from typing it out. regards terry

he mdf file on the production server is located in a folder that doesn't...

Looks like this

exec master.dbo.xp_cmdshell 'dir c:\temp\*.sql'

you can pretty much do anything you like

for exp

exec master.dbo.xp_cmdshell 'copy c:\ted.txt h:\ted.txt'

and so on

Terry

sounds like you auditors and IT directors are idiots. However, I would follow this to the letter and when a system goes down or a back up fails you need...

Yes it is possible to have no deadlocks, however, in this day and age most code is written badly, however, if you do get deadlocks there is no need to...