Install the Client Access drivers on the SQL machine and it should work fine. We had linked servers from SQL2K to AS/400 and people could query through SQL Server and...

Different protocol in use, not text.

You cannot have a trigger on a view. A view is materialized when it's called, it does not exist on it's own.

Why not a trigger on the underlying tables?

Why are you re-initializing subscribers? That usually drops and rebuilds the table, so triggers would be deleted. You'd need to add them back.

Don't reinitialize. You shouldn't have to do this.

Run a DBCC CHECKDB on the db and I'd also try a select * from the table (no WHERE) to see if you can read all rows. This sounds like...

The install should write something in the log file about where it failed. Look at the bottom and work your way back to an error (get past the cleanup/rollback). The...

You do not need to recompile if you are cleaning up fragmentation. The plans don't take fragmentation into account that I know of, just statistics. If you have a huge...

This isn't a solution, but can you not stop the backup job from SQLAgent? Does it show as running?

Also, is this only backing up one database? I'd also dig into...

That's what you have to do unless you remove the FK reference.

The references usually exist so that you don't get child data that's orphaned, or lost without a parent.

The hosts files doesn't require a reboot, but not sure if that's cached. If it is, that's an issue.

2 - Replication will still run and wait for the server to...

I'm sure traffic is much worse in places other than Cambridge. It's felt small, and a contained craziness to the driving. I'm just not used to people going up on...

Rob,

It's just here to teach you something about the product, not propose a solution. If we had E, then everyone would answer and not look it up

Good you like your job, James and the extra hours are fun when you do.

good resources and you might be right. I know it's worked for me in some simple projects, but the time to get up to speed was long. Much longer...

A bullet to the disk drive? You hunting moose up there in Alaska?