Have you already re register the DLL. Maybe you have and old version in the client machine

If you are using a command object, then you are not especting any result from SQL.

If you are going to execute something that will return a result, then use...

If you create a master server, with all your other servers as target servers, then SQL automatically control the status of the SQL Agent, and you could read remotely the...

I Guess you could create a script that executes the cp_cmdshell 'NET Stop SQLServerAgent' command. But you coudn't schedulle it with a job, so you should use a batch script...

Also prefer using joins. Indexes on joins are very important for performance.

What seciurity settings are you using for the linked server? Can you post the query you execute?

you could use a trigger with the CASE sentence.

I think is a problem of version with MDAC.

Try using snapshot.exe, you can read for the parameters in BOL. I used them always because they show more info an errors.

Are you running the snapshot agent because you need...

You can't restore from SQL 7 to 2000.

You can upgrade to 2000 and restore or script the db, and create a DTS package (or use bcp) to move the data.

...

If you finished restoring all your backup files, until the last log backup, qith QA you can execute RESTORE DATABASE dbname WITH Recovery.

Of from EM you must reinitialize the restore...

Agree but for example when you change the login account of the SQL Server or Agent service with EM is not the same than doing it from the Control Panel.

EM...

If the restore process already started but the db is still loading, then I guess

that you executed the restore with the option norecovery.

If you have multiple files to restore...

Is this snapshot replication?

try re initialising the subscription.

If you change the authenticacion mode of SQL, you must restart SQL Server to take effect. You can do it with the xp xp_instance_regwrite. But it changes the registry so...