Yeah, that solution sounds familiar. I think I did the same.

Glad you worked it out. Good job.

I think you may have misunderstood me. I have trouble with arrogance because I keep overshooting straight into hubris. (Yeah, I'll let you look that one up before...

Your test has more variables in it than just Try/Catch. For example, the time to return the result-set to the connection and paint it to the screen. (That's...

The only one that does what? 🙂 🙂

Jeff Moden (7/21/2008)

---

Awesome articles, Gus... dunno how I missed the second one, but I just read it. Really nice job.

My only suggestion to everyone is to NOT audit inserts....

Start by looking up the word "scalar" in a dictionary. (OneLook.com is good for that kind of thing.) That should make it much more clear.

I usually use SSIS for that.

RedGate SQL Compare or ApexSQL Diff will do that for you pretty efficiently.

The only other thing I can think of is to use a command-line connection, instead of Management Studio. I'm not sure how to do that (I've read about it,...

I don't have time to rewrite proc for you. If someone does, they'll need you to provide the table structure and some sample data, and the desired results from...

I'm not sure of the exact cause, but it's probably because it's being stored outside of the usual row structure of the tables.

But I have to admit that I'm kind...

I had to solve that once. I think it was a permissions issue, but I'm not sure. Check that out, and hopefully someone who's solved this more recently...

Look up Union and Union All in Books Online. That should get you what you need.

You have a few options. One is a trigger, another is the update proc, another is the front-end code.

The easiest and most consistent is probably a trigger, but that...