What is the definition for a "table...

Who is the owner actually?

I would say to assign a valid sql login as owner to your job. Other than you're administering the instance through that job (this requires sysadmin),...

Andy, the forum chat you've sent me to may be confusing. I do not use Standard edition, however BOL clearly states this recommendation for x64 Entreprise or Standard. This is...

If you create the same logins, which means you are creating different sql server logins but having the same name as for your initial instance, what will happen when you...

Andy, I'm curious what does...

As with sql 2k5 memory architecture, specially on x64 (keep in mind that AWE is enabled by default here), it is highly recommended to set up the min/max memory for...

This info is here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/5acf7585-fd64-4902-863b-f0132e0b478e.htm

The fix should be applied on the instance you're running the distributed query from.

However, this is not the problem here; doing this from within a trigger is causing the hassle....

I would say to drop the columns and re-create them again. Then select top 5 * and see if the columns are there.

You said "no errors" - check the error...

This looks as a known sql 2k5 bug that has been solved after sp2; please take a look here http://support.microsoft.com/kb/937517, however there may be more than one reason...

You can design your solution following the instructions in Allan Hirt's book Microsoft SQL Server 2000 High Availability; log shipping together with clustering is very much a good and old...

It's hard to say what that means as your error may appears for a long list of reasons; however, it's good to check if your sql server service has "performe...

http://support.microsoft.com/kb/317375

this will help

don't drop it yet; just run the WITH RECOVERY query from a new query window

As a matter of fact, just change your db recovery model to simple if you do not need log backups; this will keep an appropriate size for your ldf file;

good...