It's possible, it's not recommended. The witness is there to cast the deciding vote as to whether the principal is down or not, it's not going to be of much...

crazy_new (6/19/2014)

---

Hey sorry man, the problem was where I define the case id like

SET @CaseID = (

SELECT

bl.CASE_ID

FROM

Patricia.dbo.BUDGET_LINE bl

JOIN cat_transaction ct ON...

The code you've posted can't throw that error, a SELECT MAX().. with no group by can't return multiple rows.

Are you sure that subquery is the cause, not an other subquery...

The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

I'm pretty sure I've linked these before:

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Is this the 2005 server?

If it's critically important and must be done now, the best thing you can probably do is get someone in...

Offhand no, but I'm sure google will have several.

Don't.

It's got a nasty corruption-causing regression bug in it. Wait for the next CU or post SP 2 hotfix, then apply it and the CU

Koen Verbeeck (6/18/2014)

---

Sean Lange (6/18/2014)

---

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of...

Sean Lange (6/18/2014)

---

They send me a PM with a vague description of something and ask me to help them figure it out. I don't want to ignore them but I...

Because it's better to have the rollback take forever with the DB unavailable than for the rollback to run while...

The trigger assumes there's only every 1 row in inserted. If you update multiple rows that will not be the case.

You need to change the trigger to handle any number...

You don't want to reboot it for no reason though. Sure, reboot for OS patches or stuff like that, but rebooting just for the sake of rebooting, no.

Reading material before you make this change.

1) http://www.sqlservercentral.com/articles/Administration/75461/

2) http://www.sqlservercentral.com/articles/Administration/64582/

Create a temp table, insert the results of the DBCC into there (use EXEC (DBCC...) ), then select from the temp table.

jasona.work (6/18/2014)

---

That explains the deja-vu when I saw the same person walk...