Viewing 15 posts - 106 through 120 (of 126 total)
Hi again,
found the problem.
A scheduled job will only run if the schedule is active. -- Bugfix already reported to M$ 😉
One day when I'm a big boy I would...
December 5, 2007 at 3:47 am
Hi Chris,
I got the idea about the tables being removed and brought back in. The problem is, the batch operations at night make large changes on 90% of the...
December 5, 2007 at 2:44 am
Hi,
@Noel: I know that it's only pausing the subscriber, but that is exactly what we need to get the "photo" of the system as it is.
@chris-2: The...
December 5, 2007 at 12:43 am
Hi,
I found the way to do it properly by taking one of the replication distribution agent jobs and unticking the active flag in SSMS and showing the changes in a...
December 4, 2007 at 5:40 am
Tell me about it..... we etach them stuff about SQL, even though we supposedly don't have the experience!!!
Ahh well, it's a great learning experience for us (and hopefully for...
October 22, 2007 at 12:59 am
Hi Rudy,
the software is a CRM system and we are the thrid customer for the software company. They are Java Developers with little to no SQL knowledge. We...
October 19, 2007 at 12:32 am
Hi Grant,
it is a search, so I was right in thinking that the index should be made up of both fields. I will obviously test this before putting it...
October 16, 2007 at 12:35 am
Hi Colin,
the query grabs the MailingID and the ErrorID, I was really only using that as an example to try and find out if an index with both fields is...
October 15, 2007 at 8:52 am
Johan,
all I meant was that not only Americans were affected by what happened. Plenty of non-Americans lived in NY and worked in the WTC who died on that day...
September 11, 2007 at 4:16 am
---Steve Jones
---PS - For those of you in the US, a moment of silence for those lost on 9/11.
For those of us ON THE WHOLE PLANET, a moment of...
September 11, 2007 at 12:38 am
Hi Joe,
I recently installed/ran the performance dashboard report that can be downloaded from Microsoft.
On the dashboard I was shown that there were Network I/O waits which could be classed as...
September 6, 2007 at 9:43 am
He can't let go and ends up writing stuff that doesn't get documented (documenting is something he shoves in our faces when we don't get it done).
Best thing is though.......
September 6, 2007 at 8:56 am
Hi SQLGuru,
I just checked what you suggested and the configuration was already setup as you recommended.
We are wanting to make a clean install in the near future and swap to...
September 6, 2007 at 8:26 am
ahhh the blinky blinky things..... those little doofers next to the thingumybob right?
We have an IBM DS400 storage bay, it is attached to...
September 6, 2007 at 12:50 am
Hi,
so there are two possibilities:
1. Go through the steps that I listed above (Turn AWE on etc.)
2. Swap out the OS and SQL Server for 64 Bit versions.
Well then.... off...
June 21, 2007 at 1:02 am
Viewing 15 posts - 106 through 120 (of 126 total)