A couple of new finds to add to it.

The Box is x64 and the SQL is 2000 SP4. It's also SP2 and that explains the problem with the DTS editing...

I've toyed around with a few programs but I'm always concerned about which ones are safe to use so seeing a discussion like this develop is nice.

We currently have two...

I got it from here : http://www.sqlservercentral.com/articles/Administration/orphan_user/853/.

After running the first part the check no longer found a reason to run the second part so that answered my question....

ok. Thanks for the replies.

sp_help on table gives:

ame ...

"Only use SETUSER with SQL Server users. It is not supported with Windows users."

This is a Windows user.

Ok, so I run the following:

GRANT DELETE ON dbo.table TO user

Then I give them Execute on the stored proc.

They get the error:

Server: Msg 3704, Level 16, State 1, Procedure usp_storedproc,...

Michelle Ufford (4/7/2009)

---

Jason Crider (4/7/2009)

---

They have never had the load that we are giving them and the application (mainly the database) is having trouble keeping up. There are tons of...

Not very well at all. The previous implementation of their...

yea, I just ran a test to see and it is the same.

I need to ask the static question.

As others have stated, this is a third-party application and I have...

My understanding is that there was a different cost(with the engine) to the following options:

TableA has 5 columns and 200 rows.

I need all columns and all rows every time.

Option 1:

SELECT...

It usually helps me to have a profiler trace to look at as well.

Really. I think it's because it's in the SQL...

Jack Corbett (3/31/2009)

---

I'd recommend...

Don't forget about the microsoft link that discusses their fix:

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

I believe that the best method is that one, and if it doesn't work then you try the wrapper.