Thanks Dick. I have plans for all those items you mentioned in the pipe line. Hopefully, I'll have it all done tomorrow.

well, my replication was working correctly last night until I stopped the subscription and used a new profile which has:

maxDeliveredTransaction = 70000

I read multiple places about this parameter. The...

no open tran on the subscribers. when I run dbcc opentran() on the published database, I see:

Transaction information for database 'dbName'.

Replicated Transaction Information:

...

hi,

not sure if this is the answer you are looking for or you have found your own solution.

In my environment, I take backups from one server and restore it to...

man, this forum used to give me my information faster than I can figure it out.

Declare @db varchar(50)

select @db = 'db1'

declare @Sel nvarchar(120)

set @Sel = 'Select * from ' +...

Okay, after looking into this some more ... I found out that the problem is when joining on sys.indexes.

if I'm on the master database, sys.indexes will only return the indexes...

I've tried to create a new alert but which of the severity should I be using?

nevermind, I see how it is done.

**

Still if someone knows how to do this...

hey, where did you read that it was a bad practice to have database owned by 'sa' ? Can I get a link?

thx

hi,

I was wondering if there's a white paper that address the question posted by the OP. In the past, I've always set the database owner to sa, but at...

Thanks to both of you!

Thanks for all the explaination and feedback.  It got me mad because he brought it up during an all project meeting and argued it with in front of everyone ... wasted...

lol, yeah, I'm gonna send him the BOL info for schedule and job.

I did this morning, he's still debating it but I'm not responding to any of his emails.

thanks, that's what I thought except this idiot co-worker keeps whinning about how the scheduled portion of the job will still run even if the job itself is disabled.

ninja, thanks for the response.

does that apply to all jobs because the job that's in question is a merged replication job.  personally I know he setup the replication job incorrectly...