Slightly crossed posts =)

I though activescript was some method within DTS specifically for sending stuff to a web page or com object =).

Tryiing to find some information on accessing a...

My other option is to create a VB script that can do pretty much most things via OLE/ADO and schedule that. I would like to use an SQL dts for...

Thanks for the leads, looking up activescript now. Do you know any good internet resources for activescript..?

Rolf

Have no re-written the update scripts and split the one update query into single update queries for each column that can/will change in the DTS task.

It has cut down on...

Another quick update.

Although removing the rogue trigger helped prevent the timeouts, the replication agents still weren't happy. Eventually they just gave up and reported they werent registered properly. So back...

At last I think I may have worked out what was going wrong.

Somewhere along the powercut restore line an old test trigger had been reapplied to one of the replicated...

I ran the DBCC checks no errors. Have dropped the publication/subscription and recreated same error. If I try to run sp_dropdistributor I get an error telling me;

could not drop. This...

Have dropped the publication/subscription and recreated them with the same effect.

I have removed all the subscriptions and none of the tables etc are enabled for distribution but when I run...

Another update.

Well it definately appears to be the subscription that is causing the problems. If I stop synchronising the subscriber the timeouts stop. I cannot trace down a list of...

OK problem is back!

Dont know if this is related but when I watch the replication every now and then it comes up with a 3 transaction change that involves over...

Hi,

Well I stopped all the jobs that update the local database from source data. Deleted the remote tables then exported them form the local to the remote DB. Then recreated...

data isnt a problem as its all replicated stuff except for one or two tables..no DTS or jobs or SPs.

I will get the sysadmin to drop and recreate the table...

cant do that, dont have the neccessary permissions on the remote server to run that check.

Just tried exporting the table from my DB here to there and it crashed out...

The table is now refusing to open in any way..I cant get hte schema, I cant run a dbbc checktble on it...Tried dropping and renaming. Definately something criticalyl wrong with...

Tried DBCC;

There are 1120 rows in 43 pages for object 'redcom.products'

DBCC execution complete.

I have since dropped the subscription and then the table and then recreated and reinitialised the replication. I...