Pradeep

Did you successfully use PROCESS EXPLORER on SQL 2005, or just SQL 2000?

I was NOT able to successfully find the offending SPID via the TID Query I found in...

Thanks for the reply, SQLBuddy.

CirquedeSQLeil (9/25/2010)

---

Yes that will give them more permissions than you want on dbo.

If your goal is to allow them to do that under the dbo schema, then that is what...

Thanks, Paul! Your explanation helps.

Yes, as DBO.

I ended up doing a GRANT ALTER as stated by BOL. That worked. Although I think it allows too many permissions.

Looking at BOL, it says that besides CREATE PROCEDURE, the User must also be GRANTed ALTER Schema like this?

GRANT ALTER ON SCHEMA::dbo TO TestUser

Doesn't that give the User too much...

I did a "GRANT VIEW DEFINITION to TestUser", so now the LOCK ICONs are gone and I can do a sp_helptext.

However, TestUser still can NOT Create an SP. I'm missing...

Thanks for the reply.

I GRANT CREATE PROCEDURE to the User, logged into SSMS as that user and tried to create an SP.

It FAILED.

"The specified schema name "dbo" either...

rew-370421 (7/28/2010)

---

Also, I noticed that one of the indexes has a FILL FACTOR of 90% and the other index has a FILL FACTOR of 0%

When I do a REBUILD or...

Thank you, Gail and Jeff. I'm new to this and want to make sure I do it right.

Also, I noticed that one of the indexes has a FILL FACTOR of...

Thanks to all for your replies!

Does sp_recompile come into play her at all? Or does Updating Stats do that?

Is there a SQL2000 version of this SP?

...thanks

Thank you very much!

Thanks, George! Just what I was looking for.