We have indexed this thing very comprehensively. The code...

I want to "select" without locking things up. SNAPSHOT may be better option, but that's not turned on at the moment.

Cool. I only want it for Selects.

So, last question. What would be a good way to set it back to default?

Set Isolation Level Read Uncommitted

begin tran

select...

Yikes!!!

I fear that I owe you and everyone else on this thread a sincere apology! I am very sorry that I doubted you and that I took the tone...

I'm not sure how much smaller of a point I can check.

Example: Current "Compiled" version is

create procedure myProc @Var1 int, @Var2 int

as

begin

select @Var2 - @Var1 as...

So, if I understand you correctly, you are saying that I am mistaken. That the version of the sp that I'm getting when I use sp_helptext is the compiled...

I tried that. I've refreshed, I've quit Management Studio completely and restarted. What I haven't done is Restart SQL Server or Reboot the machine. I can't do...

I appreciate the help. But I'm asking a pretty specific question. I need to know how to "refresh" the internal system tables.

1. are you sure you updated the...