This should do it:

ALTER PROCEDURE [dbo].[sp_PRBMoneyReturned] AS

BEGIN

DECLARE

@ROW1 int,

@ROW2 int,

@TRANNO1 int,

@TRANNO2 int

SELECT ROW_NUMBER()...

I don't think that an Indexed View can be based on GROUP BY, can it?

OK, I have looked through your procedure a few times and I do not see anything wrong, but it probably does not scale very well.

I would say that there are...

Why did you add this? I do not believe that you can use INDEX hints anywhere but in a SELECT....

Amen to that, brother.

Daved is right. There are, however, some things that you can do to "encourage" it to run in Clustered index order. This this:

DECLARE @RowNum int

UPDATE...

Sure, I use them all the time, however, we were just trying to fix the OP's query, with minimal change.

Well that looks OK too.

I am afraid that I've reached the limits of my expertise. I would suggest taking a look at the Security & Network settings on the...

Were you able to get these yet?

sgardner (12/1/2008)

---

...But we treat the database as a database and try to leverage its strengths. Data does not change, while business rules are very dynamic, so we do not put...

This is a different question. You should start a new topic.

awinter (12/1/2008)

---

RBarryYoung:

I see your points on deadlocking. We'll leave that part out of the discussion for the sake of simplicity. My main objective was to see if there's...

OK, so far everything looks OK. The only odd things that I noticed were the port 587 and [enable_ssl]=1 settings on your gmail.smtp server. I assume that both...

Sorry, two more:

select * from sysmail_profileaccount

select * from sysmail_principalprofile

OK then, execute the following commands and show us the results:

select * from sysmail_account

select * from sysmail_profile

select * from sysmail_configuration

select * from sysmail_server

select * from sysmail_servertype

Also, I need confirmation on...