Kiara (5/17/2011)

---

Steve, the ordering issue is not that the results are in a different order, but that they are *numbered* results.

1. Vinay, Anup, Amit 2. Vinay, , Amit 3. NULL...

Ninja's_RGR'us (5/17/2011)

---

Why are those the only 2 options?

Why can't we have fun getting done what needs to be done and go home after that? No need for long NOR...

Balance (5/17/2011)

---

What frustrates me is that almost every business I've worked at has rewarded people who are visible for long hours rather than those who have worked hard and are...

True, though the difficulty is relative. Plumbing mystifies me and it's "hard",...

Thanks for the update. That's essentially what a few people listed as a workaround.

tabraham 36699 (5/17/2011)

---

Another ticky tack problem. Sure, I said 2, because the results were the same, just in a different order. It was the last of the two matching result...

Formatting has been corrected.

There is a download at the bottom of the article in...

Check sysjobs and sysjobhistory in msdb. Is there a job with that name listed?

http://msdn.microsoft.com/en-us/library/aa260415%28v=SQL.80%29.aspx

http://msdn.microsoft.com/en-us/library/aa260416%28v=SQL.80%29.aspx

It does not work, and cannot be made to work. This is by design from Microsoft.

You can use a third party solution like SQL Prompt from Red Gate software.

Disclosure: I...

Microsoft Operations Framework

http://technet.microsoft.com/en-us/library/cc506049.aspx

It stays connected for me. It might drop overnight, but it seems if I'm opening stuff within a few hours of each other, it remains connected.

I see people go both ways on this. Ultimately since you can't usually guarantee that xx piece of technology caused the corruption, you bring the system back online. I've seen...

What does that mean? That's a...

I agree with Sean, nvarchar won't really hurt and if you have EE, you can compress the data, so it won't double the space if not needed.

However, even uncompressed, I...