I also had trouble with AS400/SQL Server connectivity in the late 90's. I've never been able to get the DB2OLEDB driver to work, but this configuration has worked for...

Bad driving you say? Let me quote my Cuban buddy in Miami, "What do you expect, they were driving live farm animals last week! Horses, cattle, mules, and donkeys...

Okay, I'll play with it and reply in a few days after the dust settles. After some more thought, I must admit pagefile usage does seem unjustly high for...

No agents, using a remote distributor as all Push. Currently only a dozen connections mostly for Repl.

14-4Gb pagefiles = 56Gb total. About 27Gb currently in use. Lock pages...

No, sadly it's the 32-bit version of 2005 SP3. ("can't always get what you want, but you can always get what you need" - Mick Jagger)

Min/Max memory at 26,624....

Nick, I'd like to understand better why you feel there shouldn't be paging with 32Gb RAM. You've made me curious. My server initially had only a 2Gb pagefile...

I just had a similar issue on a brand-new 16-processor server with 32Gb of RAM. The pagefile was too small and incorrectly configured. Maybe this will help:

Hey Fox and others like him, going back to the original post.

I truly envy what you don't have. Here's the other side of the coin:

1. Endless supply of hardware...

I consider myself fortunate and treated fairly. I'm effectively on-call 24-7. The last time I was truely off-work was 1999 while in Europe. Ironically, I leave today...

Since no one else has replied yet, I'll take a shot. My first guess is you are not a sysadmin. Try one or both of these for more...

Maybe, just maybe, some posters could learn to use Google a bit better. Then they wouldn't have to wait for a reply from the elite gurus.

Like Naked Ape on...

Stef,

Because you say "simple", I'll offer this: Sometimes I only want to compare columns, not triggers, SP's or anything else. I select * from INFORMATION_SCHEMA.COLUMNS into...