Just to be sure, I tested my version with your original example string, and with:

DECLARE @String VARCHAR(100) = 'ABCDEFG (9105) CDD NOT REPEATING & (1690) ENGINEERING' ;

Nothing in that string...

If you don't know what string will appear twice, or if one will at all, try something like this:

DECLARE @String VARCHAR(100) = 'ABCDEFG (9105) CDD ABCDEFG (1690) ENGINEERING' ;

;

WITH ...

On the point of knowing if a certain column is updated, you can use an Output Into clause to check before/after on a column pretty easily. That keeps it...

And will skip if someone does an ad hoc Update script, or if any...

Editing that post down...

I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one table or...

From what I can see, it's a problem with Quest Lightspeed trying to compress backups. Not limited to SQL 2005, and seems to have started about version 5.0.1 of...

Dump the presenttime column, and replace it with either one column for the number of minutes present (can be converted to hours and minutes either in queries or in the...

Do you have backups you can restore from?

Have you checked for I/O issues to your data files?

Those two steps are where you should start.

Triggers don't have access to data in that scope. They just know what changed, not how.

I was going to comment about open source software being user-patchable, but I was beaten to the punch on that.

There are other drawbacks to OSS, but that is one of...

jay-h (4/23/2012)

---

terrance.steadman (4/23/2012)

---

..My apologies if I seem a bit harsh but sometimes the strength is not in attacking your foes for your own glory, but in letting the foe go...

Yeah, the documentation leaves a bit to be desired. Lots of circular definitions, last time I checked.

A "role" is a set of permissions. For example, "db_datareader" is a...

TravisDBA (4/23/2012)

---

To me, it's like having a conversation in a public park with friends. Someone might overhear me, but in general, most of what I say is limited to...

Yes, the good old, "going to work to rest up from life" type situation. Been there many times.

Hope the move went well and was for a positive reason.

Definitely good...