Most likely a typo. 'Project Mg' in one case and 'ProjectMg' in the other.

Don't those kind just drive you crazy?

Guarddata-

Good test Jeremy! My experience has been similar. The cursors of version 6.5 were very poor performers...so bad that I didn't even attempt to use them in version...

Others are more qualified to help here. Sorry for my lack of experience with the replication. You might take a look at both the syspublications and syssubscriptions tables....

Mmm..hmmm. That is certainly true.

Unfortunately, SQL2K no longer uses the syslocks table so I can't help much. However, isn't the table only viable while the lock is in...

Jeremy - I have the same understanding. I do not believe a trigger will work for this process. Other than that, the queue table works great.

Guarddata-

You may be able to modify the STATUS value and fake the system into allowing a delete.

Try this (as sa of course):

sp_configure 'allow_updates',1

reconfigure with override

GO

-- change the status of the...

Seems like that should still be OK.

SELECT G.Group, E.EmpID, E.EmpName, SUM( IsNull(H.EmpHours,0) )

FROM EmpGroup G

INNER JOIN Employee E ON E.GroupID = G.GroupID

LEFT JOIN EmpHours H ON H.EmpID =...

Ron, - since I do not understand what you meant by "The tables do not match" this may not be what you are looking for...

I assume there is an Employee...

Could it be that the "GO" statements are terminating the command? I would try removing these.

Guarddata-

I agree Jeremy - sometimes printing the SQL command is the easiest way to determine a problem.

My first impression is that I don't see code to compensate for those names...

While I agree with mgeiser in the use of stored procedures - and personally prefer to use very few triggers, I find GUIDs to be difficult in our implementation because...

You can start the transaction from the connection object being used by the page. Call the three procedures in turn, then commit (or rollback).

Guarddata-

Like so many other issues - I would say the answer is "it depends". The biggest challenge is to figure out a viable test. For a specific selection,...

Worst case scenario is to capture the identity in the trigger and spit it back out in a recordset. Not great - try scope_identity first.

Guarddata-

I have seen the ROWLOCK hint resolve strange Deadlock issues. However, I have never seen a deadlock to occur like this when the entire transaction occurs only on a...