I prefer SQL Compare as well.

You're welcome.

Good - glad you posted back that you found the answer.

See if this answers your questions.

http://msdn.microsoft.com/en-us/library/ms144275(v=sql.100).aspx

You should be ok with that.

http://msdn.microsoft.com/en-us/library/ms143241(v=sql.110).aspx

The referenced article describes a scenario of a distributor on 2008, transactional replication between a 2000 and 2005 box.

Ask the vendor if they have a rollback script.

Sometimes they do.

Kill the connections still using msdb.

But rather than that - I would likely just drop the new objects and move on.

There is logging with Michelle's too. I like to use hers because it works very well for the Index Maintenance.

That's good to hear

That index is not covering for your query. And since an emailaddress is more than just the two characters (or three since you are probably searching for com, org,...

Change your query

select fk_fha_number,max(date_final_settlement) max_settlement_date

from mf_fha_claim

where date_final_settlement is not null

and fk_fha_number in (06435113,

07135575,

09235585,

09235599,

06235384,

10135218,

09235399,

08544032,

08435265,

08535312)

group by fk_fha_number--,date_final_settlement

order by fk_fha_number

JeffRush (3/28/2012)

---

In my opinion you should provide your failed queries so we can guide you in the right direction.

No one is likely (hopefully) going to just answer your homework questions...

The second query can do a scan or seek (most probably a scan) depending on indexes.

What are the index definitions you have in place?

What is the selectability of the value...

Brandie Tarvin (3/28/2012)

---

L' Eomot Inversé (3/28/2012)

---

Do you think...

David Burrows (3/28/2012)

---

A milestone is a milestone is a milestone, don't be so damn...