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

You should firstly look a the locking on the table maybe this is not configured right. I would then do as the first person said comit the tran on each...

you must have alot of transactions, try monitoring then and asking people if they can change what they do of if they are processes try changing them to run at...

Congrats to you both , maybe I will be there oneday, 😉