Almost got me with the '.'

I prefer to use XML for this type of problem. However, i would only do this when the number of parameter values is relatively small.

Now, if someone wants to share what types of Audits they have setup for HIPAA purposes i would be able to get that promotion, jk, but it would be helpful...

Thanks for the link, i appreciate that!

I found an nice script for creating auditing triggers on thsi very site a long time ago! It is called AutoAudit. But like GilaMonster said you really need to define...

Big fan of REPLACE()

I got it wrong too but I'm not blaming the guy who asked the question! 😀

I did some research after this to become more familiar with the subject matter. The...

Thanks for the list, it's a great starting place!

Gaby,

Congrats on putting yourself out there!

Brian

Great article Jonathon! I look forward to the next SQL Saturday in Tampa so i can sit in our your presentations.

Hi,

In my opinion, your not going to get a lot of definitive answers when it comes to performance questions such as this. The reason for this is the very nature...

PMFJI,

In regards to what happens if the database designer forgets to add one of the "important" columns...

All of our tables have a "header portion", we invoked a requirement that all...

Use the WITH ENCRYPTION clause

When you setup the trace, switch over to the Events Selection tab and ensure that the NTUserName and LoginName columns are coming back.

If you just setup a trace using the...

See if this KB article helps then http://support.microsoft.com/kb/811889