Thank you very much for your replies and help.

We'r converting it to dynamic now.

All the best.

david.holley (8/24/2011)

---

ajsnyman (8/24/2011)

---

david.holley (8/24/2011)

---

...and you're thinking that the table that I posted was copied exactly from the DB? I fully understand. I was curious to see how you'd pull something...

david.holley (8/24/2011)

---

...and you're thinking that the table that I posted was copied exactly from the DB? I fully understand. I was curious to see how you'd pull something like that...

Sorry man, it will reveal too much of our internal structure, which is commercial.

The basic structure:

- Create a cursor containing all the tables you want to create the trigger for

-...

Hi David,

We did the same type of auditing on a current project and it works great 🙂

We wrote a stored proc to generate triggers for all the tables requiring auditing,...

Ok, may be some more info, sorry 🙂

In Sql Server Configuration Manager, against the SQL Native Client Config, you can add Aliases.

I need to provide a mechanism to change the...

Awesome, I just want to Google+ it 🙂

I would suggest Big Bang Theory series, geeky and laughter therapy all in one :w00t:

steveb. (7/28/2011)

---

As you mentioned that...

GilaMonster (7/28/2011)

---

ajsnyman (7/28/2011)

---

Something sounds off, I can understand to pay for each user accessing SQL even via a web service due to a connection being made to the SQL, but...

Thanks Ninja's_RGR'us, I think we past per user license and will have to get a CPU lic.

MS is killing us 3rd world countries :crazy:

GilaMonster (7/28/2011)

---

ajsnyman (7/28/2011)

---

Ok, we have a service to send emails and a print service to do printouts. So the users create entries for a specified report + parameters + service...

Crazy :crying:

GilaMonster (7/28/2011)

---

ajsnyman (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

ajsnyman (7/28/2011)

---

Cool, thanks...

Ninja's_RGR'us (7/28/2011)

---

Not really...