Actually none of the answers is correct since it does different things based on the CheckSystemDB check box setting.

Nice article.

Hmm, I thought that the ''=' ' trailing whitespace trick only worked for VarChar() fields, not char()'s?

Agreed.

First of all you have to determine & define what the Purpose of your Audit Trail is. Is it for:

1) simple diagnostics and troubleshooting of the application & database?

2)...

jwilley (3/9/2008)

---

I have a large database (137 GB) that for which we recently set up transactional replication to a single subscription. The second machine is configured as the distributor...

Geneva Payne (3/9/2008)

---

I had a co-worker mention there was a setting in SQL Server 2000 that would affect the results of a NOT IN subquery. I have looked through...

Vania Villarreal (3/8/2008)

---

i'd try to reduce de size by runing the agent history clean up job but the log file grows until fills the disk and then gives me an...

yeah...

(Oops, got it backwards. Fixed now...)

This is a substitute for [font="Courier New"]WHERE Len(..) < 12[/font]

The problem is that we have no idea what this means. You have no fields or tables called...

You have bad data in your [font="Courier New"]month_yr[/font] column.

FYI, varchar based date/time columns virtually always have bad data in them.

If you want to find them, try using:

SELECT * FROM emp_dd...

Well, here is a way to do it without functions:

WHERE Not (column LIKE '____________%')

...bored...

Yeah. It's a shame really, since so many good functions could easily be macro-ed out to easily search-able expressions in the WHERE clause.

Sorry to say, but...

In general, you may NOT modify the Sharepoint database with your own SQL because that will void the warranty.

It would be great if we could because that...