Anyone?

Thanks for you assistance. I had read about the sp_repldone but wasnt sure if I wanted to use that. Transactional replication is not set up on these databases and as...

Thanks

Thanks for the replies!

I think I might be able to work with that.

One would think so, but the last time I tried to do this without kickin them off it took nearly an hour and a half, compared to 15 minutes. And...

Good information.

Now if I put the database in restricted_user mode and attempt to add articles to the publication, when the snapshot job kicks of, it is executed on the distributor...

That's too obvious.

Thanks.

No I dont think it is my friend...

I tried to use it to run two jobs and for some reason the second one starts before the first one is even...

Not really. I dont want to call them manually. I want to script them to run consecutively.

Oh SQLServer and its stored procs....

So to run two jobs consecutively would I do something like this?

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_1' ;

GO

EXEC dbo.sp_start_job N'Job_2';

GO

Or would I put each execution in...

Just out of curiosity... can you change the distributor of an existing publication, or do you just have to drop and recreate it on the new distributor?

You can. You can put use 1, 2 or 3 servers. You can put publisher, distributor and subscriber on 1 server, or you can put publisher, distributor on one and...

Actually, the old server had the local system account on the agent and that is why I didnt figure it out sooner. Like I said, it was a dev box. I...

Well, I got the job to run.

I set the sqlserver service to run under local system and the sqlagent to run under my AD account and the job ran.

I dont...

Well, I got the job to run.

I set the sqlserver service as local system and the sqlserver agent as an AD user and the job ran.

Still dont know why...