I believe this is EXACTLY what I was looking for. It covers...

CONCLUSION:

It appears the choice to use SQL CE was a design decision and not a design requirement. The Backup/Restore History that is retained by SQL CE on each SQL...

Thanks Collin for taking the time to explain this. I have received some additional clarifying information about this from RedGate's support dept. I've actually re-typed this several times because...

Thanks for replying. We tried an AFTER TRIGGER and while this works to ensure that the DateCreated and DateModified are set accordingly and this has resulted in another issue....

SO is this the kind of question that is so blaringly obvious that no one wants to answer or is it something unheard of? Just trying to figure out...

Mike Good (8/13/2014)

---

Fully agree with Koen. The DB is created in the default data/log locations, so easiest way to control where it is placed is to set

these first....

Lowell (9/18/2014)

---

i had to do something similar, where the Visual Studio Project was deleted on a developers machine. The RDL's and all the data sources etc are stored in...

Thomas Abraham (9/17/2014)

---

I worked for several years in a one person shop. I still put comments in the code, ESPECIALLY little utility snippets. If I can't tell what the code...

Looks like I spoke to soon as thats...

I believe thats exactly it. Thanks Luis!

MM,

I am capturing the WHO (From the SQL Login whcih is unique to every user) , the WHEN (GetDate() ) and whether or not it was creation of new data,...

Michael,

Using a sepearte trigger just may be the answer in the end. I've kept all the logic in on etrigger in hopes of keeping the code to a single...

Sean,

The difference in the JOINS was a typo on my part. It should have read :

CREATE TRIGGER [dbo].[MAYTABLE_A_IUD_WD] ON [dbo].[MYTABLE] AFTER INSERT, UPDATE, DELETE

AS

BEGIN

...

Lowel,

Thanks for the script.

Lowell,

At least I've learned something new today even of it hasn't hepled with my problem; how to prevent this domain user from updating data in any table without banning access...