There's also a task in DTS (Data Transformation Services) which might be of interest.

Paul Ibison

Paul.Ibison@blueyonder.co.uk

Setting immediate updating subscribers option on the publication doesn't make the subscribers updating by default. When you set up the subscriber, you must enable advanced options (check box on the...

The report needs to take into account each possible combination, but I guess the publisher and distributor are the main concerns.

Paul Ibison

Paul.Ibison@blueyonder.co.uk

I'm no Access expert, but to get me started could you post the table script from access so one of us could create it and try the upgrade. I'm assuming...

For the first problem my initial thought is the absence of SP1 or SP2. Without these SPs the stored procedures won't be created for trans rep if you say that...

Thanks - that's what I had heard and it's nice to have it confirmed.

Paul Ibison

Paul.Ibison@blueyonder.co.uk

Apologies - have got it working now and it was something silly. I addes all my subscribres ages ago on the distributor, and ever since then when I create a...

Thanks for the reply. Something strange here, as I don't get the option : 'Some Subscribers will be Microsoft Jet 4.0 databases (Microsoft Access)' in the 'Specify Subscriber Types'...

Just starting recently, there is an excellent 3-day Microsoft Course (2591) specifically on replication. The associated file has info I haven't found in any other book, and you may be...

Excellent - it works!

Paul Ibison

Paul.Ibison@blueyonder.co.uk

Thanks Gregory - will try it out tomorrow morning.

Paul Ibison

Paul.Ibison@blueyonder.co.uk

Related to the first question, is it possible to make the query invariant on years: ie can you make this query always use the last two years, so in this...

Thanks guys, this is sounding like it may be it. I haven't got the hardware here to set up multi-server jobs, so if anyone already uses them, could you let...

Thanks Steve - using the profiler didn't occur to me. Searched for 'xp_sqlagent_enum_jobs' and 'runnable' on Google which returned two hits - both no good and looking in BOL at...

Thanks Scott - am a bit of a novice as far as this type of mdx goes, but what you posted does the trick. Have adapted it to have both...