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

I have lived in the usa, Japan and England, And I have to say the only places I love Living are London, Tokyo and New york because I dont need...

sack bad dbas too hehe

If your tranlog is full then you cant really do much, I would try to see if there are any open transactions you can do this by using the dbcc...

cheers that worked