When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
With SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy to ...
A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...