Firstly, I'll belatedly add my congratulations for a clear and concise article. It was well written and explained the intent despite the misleading title about the where clause rather than...

hilld (1/25/2011)

---

You might not want this to be installed when you are first starting to use the table. If the table has only one row, even with a valid...

GilaMonster (1/25/2011)

---

No, and I doubt it will ever be a native...

Rowcount...

opc.three (8/31/2010)

---

Rob Fisk (8/31/2010)

---

opc.three (8/31/2010)

---

Rob Fisk (8/31/2010)

---

Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example...

opc.three (8/31/2010)

---

Rob Fisk (8/31/2010)

---

Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example would something like...

I didn't use ISNULL or COALESCE becuase i defaulted the parameters to '' instead of null to remove the need.

Of course you have to ensure that the front end either...

Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example would something like this not be...

Yes,...

Sorry, missed the original question so have not investigated. Since you have worked it out then an explanation of the...

Fantastic article. Made me want to go look at it (just for the learning experience since we are a small place and don't suffer from load issues-- yet).

Unfortunaltely due to...

I normally just create a very restriced access share on the DB machine so I can grab the files off it remotely. I find that with SQL server it's a...

christopher.cormier (6/9/2010)

---

This may be a faily easy quesion, but aside from the business requirement are there any performance benefits of putting the audit trail in a trigger? I'm fairly...

To some extent I agree.

There is no need to have CustomerName in the Customer table but with columns such as ID I would never rely just on that. I would...

I did touch on that subject that in http://www.sqlservercentral.com/Forums/FindPost928963.aspx

Generally authenticated users can relay and setting up the profile to use authentication is fairly straightforward as I remember.

For my...