Viewing 15 posts - 181 through 195 (of 323 total)
Anyone?
On a side note - Has anyone ever has 2 identical servers running side by side and have them running the same queries as each other - and those queries...
January 19, 2010 at 9:33 am
Sorry to bump but does anyone have an inkling?
January 19, 2010 at 9:31 am
Ahhh! Once I start talking about an issue I usually fix it. Always the way.
Even though as part of my package I was setting the db offline and then bringing...
December 2, 2009 at 4:34 am
Getting there now (the mystery unfolds!)
I can't believe I didn't realise until now but there is a legacy trigger on this table that reports any changes to another "logging" table....
November 19, 2009 at 5:56 am
*Slaps forehead*
Data file was growing because I'd switched the Recovery Model to Simple in trying to resolve earlier issue. Therefore all activity was being logged in the database.
Now I switched...
November 19, 2009 at 4:05 am
Hmmmm now when I run the update statement I'm getting an autogrow on the data file. Why would this keep requiring to increase based on 900 updates?
November 19, 2009 at 3:43 am
Well the log kept wanting to autogrow and filling up so thanks for the tips on that.
Using dbcc opentran to confirm there are non distributed replication transactions
--Set the db to...
November 19, 2009 at 3:29 am
You sirs have helped me a great deal!!!
There are some old non-distributed replication transactions in the database (it is a replicated db where I bring it from, but it is...
November 19, 2009 at 3:03 am
Still working on this. Versions are now the same. Haven't changed the disk setup yet but ultimately this shouldn't be happening, and if it was a disk issue it wouldn't...
November 18, 2009 at 8:23 am
Just for interest - My resolution to this issue.
I had to drop the replication subsciber and publisher. I used BCP to get all 3 servers I am using aligned (took...
November 18, 2009 at 5:49 am
As I thought the log reader doesn't need to be running once it has passed the transactions/commands onto the distributor. It is still running and shows no signs of progress,...
November 10, 2009 at 2:46 pm
If I use sp_repldone to push it past all the error commands will this mean I have to drop and recreate the publisher or subscriber?! Or will it just carry...
November 10, 2009 at 11:40 am
ALZDBA (11/8/2009)
please post in SQL2000 forums for SQL2000 related questions.@@version info does matter !! Please provide it.
8.00.2039 on new server.
8.00.2273 on "old server"! AHA!
Downloading that hotfix now to keep them...
November 9, 2009 at 9:15 am
We do have some issues here and there with this server but it is probably down to performance tuning (mentioned in other posts).
November 9, 2009 at 2:48 am
Viewing 15 posts - 181 through 195 (of 323 total)