It might be different elsewhere, but the vast, vast majority of cars sold in the US have either automatic or CVT transmissions. Many cars in the US are just P,...

I agree with Wayne. We've restored quite a few tapes over the years that were 2-3 years old at times. Periodically testing things is key.

So the right of way is defined as the GVW in Alaska?

Yelena, not sure what you mean.

There's nothing to do that. I'm assuming you want to be notified when new data appears in the tables.

Best way to handle this is write a stored proc to do...

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...