I missed the London one's due to family...

If you dont want yourself to re-add access, then you will want to remove db_accessadmin also.

Members of the db_accessadmin fixed database role can add or remove access for Windows logins,...

IIFC it should automatically appear when the logfile is restored on the secondary.

The account needs the rights to stop the service, so this is usually power users or administrators.

My Google-Fu isn't strong at this time in the morning, so lookup the permissions...

http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/

Gail has wrote some good articles on indexes, use the above link and read the "Introduction to Indexes" articles.

Typically no as thats the SA login and runs system process, now depending how you have your security setup it might be that everything is logging in as SA, which...

Mini Chopper

Create a report as you want as the template, then deploy it, then ensure the users dont do save as over the top of it and mess up the template.

Please be patient, we are all unpaid volunteers posting in our own time and sometime it takes time to get an answer to a problem.

SSRS cannot natively do tabbed reports...

Yep thanks both, case of the afternoon slump, need more coffee to keep going.

WHERE

ISNULL(SUM(BF.GLOBAL_FEE_TAKEN), 0.00) < ISNULL(SUM(BF.FEE_AMOUNT), 0.00)

Your where clause is not SUMming the data, so while 10200 < 32700 = TRUE, that is not what is actually being checked in the where.

Well there you go then, you where running into the UNKNOWN section of the predicate and in turn it was filtering them out as if a value is NULL SQL...

So 0 for a Ammount paid, so is that 0 due to the ISNULL or is that 0 due to the sum of the values?

What is the value in the two columns in the where clause, I am guessing that one or both are NULL due to you wrapping them in ISNULL in the...