OCTom (4/21/2011)

---

Whoa Nelly! Hold the phone! Stop the presses!

Someone on SSC actually said something nice about developers!?!

Things are looking up! 😛

Thanks, Steve for all you and others do at SSC....

you are welcome. Please post more questions if you need more help with the trigger or update.

It would help to see code, but the result count in the lower status bar is the sum of all results. If you had a couple of batches or statements...

do you mean the result set is both rows in one field or row? This is a cross tab. Or a PIVOT.

Simply, with your example, you can do:

select a.ColA +...

If the routers were changed to block UDP 1434 (lots of network people do this), it would prevent browsing.

Thanks, CU7 is corrected.

Thanks, and I hope it does go well. I'll be writing about it more.

You don't get anything. The question was written in fun a few months back and most people in the US see Apr 15 as tax day. It was extended this...

A few things. First, you cannot use SET inside a SELECT. If this code is going to handle one insert at a time, you would move to an IF statement.

DECLARE...

That data sent by the client can be spoofed. You cannot count on those values in sysprocesses as they are provided by the client. There is no authentication here.

If you...

You're not making sense here. How does the counter for c increase by 1 when the counter for c increases by 100? Doesn't flow.

Is everything based on column a?

If there's...

I tried a dozen or so of the formats, and none of them will convert 13:10 (in a datetime) to 1:10.

The only solutions I've seen were to convert to char,...

Check the alert, and see what it is configured for. This ought to be under SQL Agent in Enterprise Manager.

As far as limiting memory, Jack is correct. You need to...

What do you mean with client_host? do you mean the host name sent through the connection? That's completely arbitrary. It defaults to the windows host, but someone can fake that....

I'd also reboot and try it again. If you downloaded the media or burned it, double check this isn't a corrupt file by installing on another machine