Apologize for the confusion. I needed to clean up the schema for viewing and didn't follow through on pk in the first post.

GUID and ID are the same field....

Thanks for replying back.

The index showed 75% fragmentation and indexdepth of 4

The server default fillfactor is still set 100% as is the index.

Data is loaded using datastage and...

Yeah - thought about last night. duh on my part i guess it's been awhile since i was on a standard edition. thanks man

oraculum - thank you for responding so quickly and providing input :-).

Jason - exactly what i was looking for thank you for putting that together.

I had two filters -

1) Include only logins that start with the letter 'E'

2) Exclude Appplications that are 'REPLICATION MONITOR'

When I run my profiler interactive this works, if...

So then you have to either drop the constraint on the subscriber or when creating the snapshot specify that the constraint is not for replication.

Again Jay fantastic job keep up the good work.

John

Yeah we tried getting rid of either of the files without success. From what i can tell it looks like this is backup of the publisher database while it was...

wierd about the attachments.

We do run traces and this definitely something we keep track of which is why I was lost on how i could have missed a...

Thanks Grant,

I've passed it on to the developers and agree with your analysis. I'm not sure how much code they would have to alter to change from a NULL...

:blush: Now I know I've been working too long.

It was the column being dropped and seeing end time for my program names that had me baffled.

Repl...

Thanks everyone

Is this the right forum for this question? :unsure:

Agree with all it is a nice script for 2K and under. Well done!

Unfortunately we never do backups so it would be moot here 😀

Thanks All !

I like the rank approach and have already passed it on to the staff.