From an audit/risk perspective, yes, they can read data in a diff file, as noted.

In terms of mitigating risk, you can use encryption, which isn't perfect, but nothing is. However...

As Lowell noted, the procs will be in sys.objects. They'll see them in SSMS. AFAIK, you can't hide that.

I think, searching memory here, that you could get SELECT privileges to the job tables and grant them. However that might mean the person could only query.

As far as DTS,...

There's the SP_OA procedures, but they would contain similar risks. Is this SQL 2000? If so, then the risk is that someone will run some malicious code on the Windows...

The immediate risk is that you write a poor query and delete the wrong data.

There's no logic in SQL Server for this. You'd need something to scan the SQL log and send you an alert. However, you'll need to define this. Do you mean...

Do you mean a tally table?

Search "tally table" here for Jeff Moden's article on building one.

erichansen1836 (9/24/2015)

---

Lets use MDB files then for the RESTORE LOG as well as the database.

an MDB file (new one daily) with no indexes and no OBJECTS except for one TABLE...

There is no question, just observations on what you've described.

Lets use MDB files then for the RESTORE LOG...

erichansen1836 (9/24/2015)

---

but there are no shortage of instances in the SQL Server/MySQL/Oracle/other RDBMS world where people have had issues because they depended on application logic to maintain data integrity and...

I can see how you view subjects as a general concept as separate from the instance of a subject. I have reworded to ask about classes.

Thanks, fixed.

You wrote:

"

I checked on this at:

http://www.microsoftstore.com/store/msusa/en_US/pdp/SQL-Server-2014-Developer-Edition/productID.298540400

But found one unhappy purchaser who wrote:

"

implying that developer won't work. If you don't see the implication, I think you're not communicating well in English....

erichansen1836 (9/24/2015)

---

In the below while LOOP, as each SQL INSERT is performed (Not committed yet), I would build my RESTORE log within an array, then if the complete set of...

erichansen1836 (9/23/2015)

---

I checked on this at:

http://www.microsoftstore.com/store/msusa/en_US/pdp/SQL-Server-2014-Developer-Edition/productID.298540400

But found one unhappy purchaser who wrote:

I bought it as a Developer Edition, but it has functionality as EXPRESS - only 5 GB database. I...