Hi SQLBill

thanks for the thoughts. Hmm, I need to mull this over. My concern is that I don't want to disable the website's access to the tables!

Hi SQLBill

thanks for getting back on this.

To put some precision around this..it isn't actually that there are 2 tables with identical names under different schema.

As I mentioned, before the DB...

Hi

I have another thought about my "invisible data" problem..

My DB had to be restored about 10 years ago and I found that objects created were no longer dbo. but the...

I got a reply from my host's tech support and they told me they couldn't think of any caching issue that could be causing the problem.

Regarding referring to a different...

Hi SQLBill

I looked through the database and there are no views referenced by the website, it uses queries.

Hi SQLBill

thanks very much for your thoughts on my problems..

I think I have to agree with you that the data is in the database as I can query it. My...

Just read my post through again and I should have added that the error referenced in the part about importing data with SQL Server 2014 Import and Export Data only...

Hi

thanks very much for all the thoughts on this. Several tools to think about and investigate but probably SSMS is the rational way to go..

Cheers

Hi

thanks for the info and glad to hear that I'm not boring everyone with the hundredth post on this!

I've actually only just found out about the issue as my...