Yes, RAID Drives - What I meant by safeguard is that it's a level of protection above a single drive system. Hence, like a physical safeguard device with machinery -...

Well, they have to accept it. It's a...

I think the crisis is over.

Thanks so much for your help Anthony. I can't express how much I appreciate your quick help and how I liked your approach - providing...

Thanks for the info. While I was waiting for your reply I was searching for the answer myself and came across a MSDN entry.

- It looks like a Wizard...

Hi Anthony,

You're making me smile.

I poked around and found the database ...Properties > Options > Recovery Model > ...

The ERPdb was set to Simple.

My ERPPlusDB was set to Full. I...

This is great! Yes - I'm tired of looking up the details too. I'm glad I found this post.

Thanks!

Thanks all for your advice and help so far. I think I'm getting close to getting my head around indexes - as in, my mind "sees" the solution and it...

Chad - I really appreciate your taking the time and effort to give me a lesson in indexing! Wow. That was a comprehensive reply. I reread everything a few times...

And the plot thickens... :laugh: :crying:

Well, that is exactly what I did!. My notes from reading about indexes are not correct. I thought (wrote in my...

BTW - the Front End is Access, rarely use Pass Thru queries.

Gail ... Thanks for the information about NVARCHAR. Did NOT know that. Googled and found a Tech Republic webpage...

That was easy! I didn't realize that tables in different databases could be joined, because I had never seen anything to join them. (Just did a search and read that...

OK, I'm going to try and build a command in SSMS (2008) Query editor using SQLCMD. From what I've read in my searches, I can use SQLCMD, I don't have...

LOL ...

Tom, please accept my apologies. I was joking when I said, "Can you make it any easier?"

That's about as easy as it can get.

Thank you for taking the time...

Can you make this any easier? 🙂

I wonder why I couldn't find anything when I Googled - I spent almost 3 hours searching.

Thanks so much.

Thanks!

I've been trying to test drive your solution - I see the technique you are using.

Been getting interrupted and haven't been able to focus on this long enough, also need...