SQLCrazyCertified (1/8/2013)

---

Thanks, I did that.

I ran dbcc chekcdb(dbname)....and looked at the error, I see an error 'An error occurred in the service broker manager, error:823, state 2.

I also see another...

Evil Kraig F (1/8/2013)

---

Scott D. Jacobson (1/8/2013)

---

hisakimatama's latest post is beyond frightening. This is like saying "I need you to be a DBA but also drive a tractor trailer". There...

Grant Fritchey (1/8/2013)

---

hisakimatama (1/8/2013)

---

No kidding. I saw the SQL-related bits and figured the salary was acceptable enough, then I caught the rest of it... Ack. Amusingly, there's...

I have had Apache cause that several times for me. I have even had malware scanners cause it.

Each report has different parameters I would assume (to at least query different data from the database). Why not add an additional query that sums all data being summed...

At this point I would go the MCSA and MCSE route.

Thanks for the question.

dwilliscp (1/7/2013)

---

SQLRNNR (1/7/2013)

---

dwilliscp (1/7/2013)

---

GSquared (1/7/2013)

---

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to tell,...

If you stub a proc with the same permissions, do you get results from the openquery piece of the query? Eliminate the Join and the insert - make sure...

Good to hear.

Yippee skippee - thanks Ron.

dwilliscp (1/7/2013)

---

GSquared (1/7/2013)

---

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to tell, from what...

And the linked table, does this role have the appropriate permissions on it?

Have you tried to run the proc while logged in as a user in that role (not yourself)...

Looking at this query, I wouldn't look at indexes with an improvement_measure of less than 1000. But that is nothing set in stone. It is a starting point.

What...

Does the table involved in the insert, or any of the tables in the non-functioning sp, have deny permissions for the users or role?