It sounds to me that you're going about this the wrong way. You're focused on a single solution to the problem (i.e., that it was indexes) without actually checking the...

Sorry it took so long for me to reply. Been busy at work.

On that screen shot you took, you forgot to check a box right above the path information you're...

Sorry, my company blocks that site. Can you attach the image to your next post?

This is why we asked about versions. Workstation...

Are you sure they're hitting the correct instance? Because if there's both a named and a default on that server, they're no longer hitting the proper instance.

They may also need...

chaudharyabhijit (5/20/2010)

---

I have a similar problem where i am saving data in a csv file from a table. I need to upload the csv file to the ftp server everyday...

Greg Roberts-134214 (5/17/2010)

---

Unfortunately, a test envioronement will not provide any impact as this is a user in the finance department building his own reports, and he thinks execution times over...

Log onto the server. Right-Click My Computer and go to Manage. Many file locks can be found under Shared Folders -> Shares or Shared FOlders -> Open Files. Sometimes, though,...

Unable to delete is different from unable to find.

Check the file locks.

It checks to see if Anna_User has a schema first. That is still a step that can be avoided if you use schema.object qualifications.

You may not notice the performance hit...

Jeff Moden (5/12/2010)

---

I haven't checked the other versions of SQL Server but...

Sorry, I was out of the office and didn't get to respond until now.

What version of client tools is the workstation using? And did you say that you logged directly...

This article doesn't actually say the server *will* recompile the proc. It says it might.

Best Practice

It is best to owner qualify stored procedure names when you execute a procedure. This...

So far as I know, procs do NOT get recompiled just because you leave off the schema name in the EXEC statement, not even in 2000. I'd like to see...

I know of no way to only allow one connection via a login. Through the server properties, yes, but not on the login level.

However, you could give this person access...