With your current design I think returning the data in a format that allows for a matrix report is probably your best option. Which means you'd also have to...

What drop-down menu are you referring to? Is it for parameters? Can you post a screen shot?

Ed Wagner (8/19/2013)

---

I think the number of people posting questions without first doing one iota of research has gone up. I also think the homework questions have increased. ...

Steve Jones - SSC Editor (8/9/2013)

---

Jack Corbett (8/9/2013)

---

Just read recently that the Cayenne holds its value better than any other vehicle in its class, so wouldn't be the...

Steve Jones - SSC Editor (8/8/2013)

---

Steve Jones - SSC Editor (8/8/2013)

---

jasona.work (8/8/2013)

---

Now nobody's trying to talk me out of this...

Hmm, pay off bills faster (albeit not a lot faster) or...

raghu_kalwa (8/7/2013)

---

Hello Perry,

I have used the SQL server profiler,.

So can you suggest me which one is best solution to take the trace on the server .

The SQL server profiler ...

That query receives (reads) the messages form the mail service broker queue and essentially clears them...

Jeff Moden (7/31/2013)

---

Jack Corbett (7/31/2013)

---

I actually like the new icons. I think they are easier to read and more clearly show what they represent. There are...

You could do something with sys.dm_exec_requests and look for the ALTER INDEX command as a start. You could probably drill down more from that to get to the object...

I agree with Erland on this one. If the person(s) needs to be able to start/stop a specific job you would probably be better off creating stored procedures that...

I actually like the new icons. I think they are easier to read and more clearly show what they represent. There are only 2 wonky things I see:

1....

Stefan Krzywicki (7/23/2013)

---

Jan Van der Eecken (7/23/2013)

---

Jack Corbett (7/23/2013)

---

Sean Lange (7/11/2013)

---

OK I will show my true American colors here. My wife's company just got a new client in...

Sean Lange (7/11/2013)

---

OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

Stefan Krzywicki (6/13/2013)

---

jasona.work (6/13/2013)

---

Stefan Krzywicki (6/13/2013)

---

Grant Fritchey (6/13/2013)

---

Stefan Krzywicki (6/13/2013)

---

Grant Fritchey (6/13/2013)

---

Stefan Krzywicki (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

Sean Lange (6/13/2013)

---

Steve Jones - SSC Editor (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

Brandie Tarvin (6/13/2013)

---

The Dixie...