One of my clients uses a VFP9 app with MSSQL SERVER databases
Two databases
database A stored in the hard disk (C:)
databaseB (with confidential data) stored in an external hard disk
(E:)
The Sql Server Management Studio correctly shows, in each database
properties windows, in the files option, that the A database resides in
disk C and the B database resides in disk E
However, if I physically remove the hard disk (E:), the management
studio still shows all tables of database B and select statements show
data from the applicable tables.
I thought that the data resides in memory in the cache. So I
disconnected the SSMS from the engine, even turned off the SSMS. Then,
when the SSMS was up again, it would still show the database B (even if
its lodging HD was disconnected and put away in a drawer) and queries
would still show data from any of the tables.
What is going on?
How can I prevent this "ghost" behaviour?
It is very important that, when the external hard disk is removed, no
confidential data can be read at all.
Rafael Copquin
---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
