You're correct. I didn't catch that you were using FranchiseID in that number. I skimmed over...

Thanks, but your solution won't work. Even though my supplied data set only has one paired team, my actual database has multiple FranchiseIDs with multiple StoreIDs. Your update will make...

He's correct. Your exec statement is the problem. You're missing a single quote right before 44.0.

EDIT: Make that before BOTH 44.0 bits.

Thanks for the info, Carolwood, But that doesn't answer the OP's question. Does that software allow for de-duplicate backup procedures?

The Query Builder does have memory / processing limitations compared to the regular query window. We've had a lot of issues with users creating workable queries in the QB that...

samiam914 (6/14/2010)

---

I am having trouble with linked server. In this linked server, only one windows ID is mapped to an Oracle ID ... it's password does not conform to windows...

Spiritual support is also acceptible. But when you do get back into gaming... @=)

It's not services you necessarily have to worry about. It's all the little things, like Linked Servers, jobs or SSIS packages that specifically call those accounts, etc.

The only way to...

Are your servers within the same domain and both inside the firewall?

If not, is your firewall open to the ports being used in the mirroring?

Crashes as in it brings SSMS down or freezes SSMS or what?

Describe what happens step-by-step please.

Do these password changes...

I don't use Data Mirroring so I couldn't even begin to answer that question. Sorry.

I don't use proxies, so I'm just guessing that your problem is the underlined one...

This is what I found in BOL.

Books Online

---

SQL Server Agent proxies use credentials to store information...

I...

SP4? Whoohoo!

And here I thought they weren't planning any more SPs for 2k5.