Happened to my wife last election cycle.

That aside, the McCain campaign...

Well, unchecked capitalism is what's failing. Things were de-regulated, people found loopholes to make money and exploit the system, and now the proverbial chickens have come home to roost.

I...

Loner, I agree. It really bites that these people play with our money, then when they lose it, we have to pay again to bail them out. There's...

Hey, Gary. I just worked on cleaning up a big address table, talk about fun! Anyway, how about something like this:

select left(Address, charindex(' ', Address) - 1) as...

Thanks for the replies. I expected 2005 to have made improvements in the lock manager, but since my experience with 2005 is minimal, I don't have research material for...

Excellent comments all around, I particularly like Gail's and Anders'.

For me, it's about bandwidth and control. The area I live in just got a second set of circuits for...

Carla Wilson (10/7/2008)

---

Wayne,

Wow, good job investigating system tables/views and triggers! (although I did not expect you to drop everything to do it - - I was just reply to...

Giovanny Gomez Convers (10/7/2008)

---

Hi!,

When I try delete a user on database, appears the next error message:

"SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options...

Slightly slow afternoon, so I decided to go exploring. My gut feeling is that it won't work in 2005 or 2008, but I love working with system objects and...

Carla Wilson (10/7/2008)

---

Wayne West (10/3/2008)

---

If you wanted to live dangerously...

I wouldn't recommend it because I'm not comfortable doing anything to system objects.

...

Oh, what the heck. I just...

Pieter (10/7/2008)

---

thanks Wayne!

We do data warehousing instead of OLTP and like the space savings associated with "set ansi_padding off". Is there a way that we can make it work and...

Good going, Gail! I hope it takes off!

I'm surprised that they don't have a "tips on starting a SSUG" at PASS in the Professional Development track. I'd kind...

Carla, have you considered experimenting with a trigger on the information_schema.columns view? BOL says you can apply triggers to views, but I don't know if you can bind them...

I'm seeing something interesting, and was wondering if someone can tell me what's going on. As an experiment to see what would appear in the log, I modify a...

You might double-check your code, Joanna, the only time my audit table shows --ENCRYPTED-- is when I create an encrypted view. I assume it would do likewise for any...