Running it from a desktop PC ?? Regularly, or just once ?? If regularly, why not schedule it to run as a scheduled job...

I get those memory messages every now & then (different #s each time) .... I think it has to do with my PC, not the server

I've installed SP3a on several servers ..... No issues that I'm aware of.

Why can't you change the database to bulk-logged or Simple recovery, change type to bigint, then change back to full recovery ?

I did this with good results when I needed to change the length of a field in a replicated table.

-- Specifically: Drop a table from a publication so it can...

I needed to drop an article from replication so I could change the length of a field. Here's what I did ..... seemed to work for me. I guess...

Here's what I just tried, and it seemed to work. There may be some "gotcha's" to this that I'm not aware of.

1) I just scripted out the CREATE...

I'm in the same boat.

I need to modify the length of a field in a replicated table. After dropping the subscription, the table's check box is visible, but won't...

Was an AS/400 programmer analyst at a few different places.

Before that:

R & D at Cannondale Bikes

Boring job at a thermometer company

Tool & Die at Pratt & Whitney

Night job making snow...

I've come across the same thing .... now I only use the count from EM properties as an approximation. I use select count(*) from either QM or EM if...

We did something like that ..... Used IBM's MQSeries product to transmit data from the web to AS/400 ........ Maybe IBM's WebSphere would help too...

I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....

Thanks for the help !

If there is a main field you would want to know this on the something like this

SELECT fldIwannaC

FROM myTbl

GROUP BY fldIwannaC

HAVING COUNT(fldIwannaC) >...