OK, Allen but I do not have a support contract and I confess you that I gave up of asking for free support at Microsoft because they never answered me...

Hi, Tony!

I´ve been having this problem with high frequency and I always solve as you did: restoring a full backup but; but I have some databases with 30GB and sometimes it...

Hy Tony !

I´m having the same problem as you; I posted a question today with the same problem ... Could Not Redo Log Record...

Ops, I forgot to say that my environment is

Microsoft SQL Server  2000 - 8.00.780 (Intel X86)  ===> sp3a

 Mar  3 2003 10:28:28

 Copyright (c) 1988-2003 Microsoft Corporation

 Standard Edition on Windows NT...

Do you have more then one processor at this server ? If so, may be the optimizer choose paralelism to resolve the query. If that´s true, try to rewrite the query especifiing...

Hi, Roust_m!

This occurs because sa must be defined as a remote login. Add this line at Server2:

sp_AddRemoteLogin 'Server1','sa'

This ´ll solve your problem, OK!

Hi, I´ve a sp that reads the registry and is very useful:

create procedure sp_DBA_MDACversion

as

DECLARE @Ver varchar( 255 )

EXEC master..xp_regread N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\DataAccess',

N'FullInstallVer' , @Ver OUT , N'no_output'

print @Ver