SSIS typically runs as a job under Agent.

If an Agent job issues a BACKUP DATABASE, it is no different than if you issue it from SSMS. SQL Server still...

We will publish the list of mentors after the applications close. We want this to be about mentees and mentoring, not about the mentors. At least, that's this part of...

Dan.Humphries (4/21/2011)

---

I like your responce to a bad situation. I often feal bad for the ticket agent in airports as they get screamed at. I think people forget...

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,...