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

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

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

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

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

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

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

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

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

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

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

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

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

ahhh the blinky blinky things..... those little doofers next to the thingumybob right?

We have an IBM DS400 storage bay, it is attached to...

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