Another option that might work for you would be to add the WITH COPY_ONLY option to your BACKUP LOG command.  This will then leave the transaction log intact after the...

I've yet to work in a shop where Windows Authentication was an option for the same reason you are experiencing.  Yes, it's better if you can do it that way...

Hardly worth mentioning as I'm sure you have done this, but are you setting the database context? for example, selecting the correct database from the dropdown list or putting a...

I've never heard of any performance issue with using mount points. On the contrary, as mount points can be on different disks \ raid's \ SAN's, you get flexibility...

That is correct - just add any additional criteria to the WHERE statement

If I have understood you correctly, is it as simple as this?....

select CaseStatus, Case_Group, CASE_GROUP_TOTAL = COUNT(*)

from MCJ

WHERE Case_Group IN ('INPATIENT', 'Outpatient')

GROUP BY CaseStatus, Case_Group

Unfortunately the cluster service failed over last night so now I have nothing to go on. I will continue to monitor the box and come back to you if...

Sorry Grant - I'm sure it's just me missing something, I found that query but it just seems to back up my point which is that there are very few...

I understand that as a concept Grant, but what I don't understand is.....

1) Only one of the databases are in production and they haven't been queried since the last restart,...

Looks like it'll be a mapping table after all then.

Dwain, Eugene, Jeff - Thanks so much for your efforts. I'm in awe of your brainy-ness and committment to the...

Eugene - I didn't even notice your post earlier as I was posting at the same time. It's an excellent solution but sadly fails for the same reason as...

I hate to throw cold water all over your efforts Dwain, but it appears the output does have to be an int and not a decimal. I think that...

Sorry Jeff - yes, exactly as you stated - 0-9 and A-Z (upper case only) characters for Value 1 and only 0-9 for Value 2?

Thanks again, Jeff - I'm even more impressed now.

Jeff, I think that Dwain is setting some pretty high expecatations here! Personally, I don't think that there is a solution...