Can you not even be bothered to type "TSQL MERGE" into your favourite search engine? Jeez...

Ok, I've thought about this some more and have decided that it doesn't make sense to do what I'm trying to do with the ParallelPeriod function so I'm using LastPeriods...

Turned out it must have been the settings on my machine at work as at home I can see your original images fine - sorry!

I will try and replicate your...

It may be just me, but I can't see any images. Could you try attaching them?

Rarely and no, it wouldn't qualify as an event. I'm waiting to hear back from 'the Business' on whether they are interested in analysing data by individual qualification and their...

Why would you not have just a single Status dimension which would include (as a minimum) StatusKey, StatusCode (the natural key, e.g. 'O' and 'C' in your example) and StatusDescription?...

Now I'm missing something because you stated in your original post that you had to manually assign the roles, not link the user to a login...:ermm:

Anyway, you've resolved the problem...

Yes, see my edited post.

Sorry, I wasn't clear, I meant that you need to run Step 3 on the Mirror before you activate the mirroring session.

Actually, just thinking about this some more, when you...

Thanks for providing the steps. If you had run step 3 on the Mirror, that would've prevented the issue I think - I will test it out when I get...

Neeraj Dwivedi (5/13/2013)

---

...While I was doing that I just realized that the default database for the Application user being as "Master".

So anytime the failover was happening the user was able...

You didn't specifically answer my second question. Did...

So if I understand correctly, you have created a login and associated user on the Mirror that match those on the Primary; is that correct?

On the mirror, did you...

Jeff,

Does your solution work for users that do not have a direct login, i.e. they have access to the instance via Windows Group membership? A frustrating afternoon of trying to...

I took the schema change part of the question to mean that the schema to which the table belonged changed, e.g. from 'dbo' to 'Person' in which case the correct...