Hrmmm... was afraid that you were going to say that....

Thanks,

Chris

Hi there,

I have the system and clients patched to 3a and both are running with the latest mdac service patches.

I basically, to get around this, did an evil hackola where...

You can do DMO in just about any language which supports it... even Perl.  Just finished an ASP utility that does replication done up all in vbscript (although I dont...

Hi there,

Nope, between wouldn't work since the numbers could jump all over.  Found the following solution:

-- Adding the article subset filter

Select @ASTR = 'exec sp_addmergefilter @publication = N''' + @DB_Name...

I like your way better, thanks!

Chris

what type of replication?

What I've had to run to make sure my scripts are starting clean for merge replication are as follows:

'Drop any subscriptions

exec sp_dropmergesubscription @publication = N'<publication>''

'Drop the publication

exec...

Ok, I got it figured out.  I had 3 things going against me

WaitState(10000)

for each oItem in SQLServer.JobServer.Jobs

     If instr(1,oItem.Name,"DYNAMIC") Then

          Do while...

Actually I ended up doing this before I saw your reply:

Declare @JobID Binary(16)

Select @JobID = job_id from msdb.dbo.sysjobs where name like '%DYNAMIC%'

exec msdb.dbo.sp_start_job @job_id = @JobID

My next problem is how...

category was what I was looking for, thanks

Chris

The front-end is an ASP application.  Need to be able to push the data back into the main server whenever the user checks the items back in and I dont...

Actually its more can I DYNAMICALLY, from the subscriber side PULL the records I want from a publication.

The core tables are just that, static information that is not editable in...

If I was to do a select statement from the [Warrants] table below off of intMasterAcctID I would get two rows returned for intMasterAcctID=1

The function basically returns the intMasterAcctID, Warrants...

you should be able to

exec (@stfield)

after while/end.

regards,

Chris

Actually thats just about perfect for what we need.  Gets rid of the need for that damned cursor and almost all of that code. The 10A 10 2 should be returned...

Frank is close but I unfortunately did not think the entire post thru before posting...

Typically vchrMap,vchrBlock,vchrLot are all varchar(10).  The alpha character(s) can be any position but the first.

I came...