Viewing 15 posts - 31,786 through 31,800 (of 39,819 total)
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...
July 31, 2007 at 8:12 am
Different protocol in use, not text.
July 31, 2007 at 8:10 am
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?
July 31, 2007 at 8:10 am
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.
July 31, 2007 at 8:08 am
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...
July 31, 2007 at 8:07 am
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...
July 31, 2007 at 8:06 am
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...
July 31, 2007 at 8:05 am
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...
July 31, 2007 at 8:03 am
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.
July 31, 2007 at 8:01 am
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...
July 31, 2007 at 7:59 am
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...
July 31, 2007 at 7:41 am
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
July 30, 2007 at 12:10 pm
Good you like your job, James and the extra hours are fun when you do.
July 30, 2007 at 12:00 pm
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...
July 30, 2007 at 11:59 am
A bullet to the disk drive? You hunting moose up there in Alaska?
July 30, 2007 at 11:53 am
Viewing 15 posts - 31,786 through 31,800 (of 39,819 total)