Thanks for the replies. The data is in memo (word processing) format on the source and can carry up to 32,727 charachters. I chose one single record that...

Thanks. This will help a lot.

I found the links and have built queries to get the information as needed.

Thanks. This has save me considerable time.

Thanks to all for your input. A couple of items:

Yes, the data is all updated via batch processes with all but a very few updated on off hours.

The data...

The current db is around 323 GB in size.

The data is purely batch update and used for reporting, but the vast majority (99%) is using MS Access by numerous users....

Thanks for the input. Your response is very helpful and gives me what I want to know. Basically, we have not used SSRS or SSAS at all for...

Yes. I have contacted them and an individual has been assigned but no response at this time. My previous contacts with issues have been that when the vendor...

I am not familiare with powershell but it looks like I should be. Thanks for the suggestion.

Thanks (to all) for your help. This worked perfectly.

Thank You. I will download and check to see if it works for my goal.

Perfect! Thank you very much.

Just what the doctor ordered. Thanks a bunch.

1. I may not have explained correctly, but the max does seem to work on another table with a definition of Varchar(max). Below is a sample code to...

Kevin,

Thanks for the advice. Although we did not actually find the problem we have "fixed" it for now. The SQL service was running and all looked good. ...

I have had this problem before and the reason was that when developed using BIDS the workstation had named letters for the data source location (e.g. C: drive). When...