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...

Whisper9999 (5/12/2010)

---

Thx. I should have been a little more specific. What I mean is that we are seeing a "perfectly fine" query blocking, as in when you...

Server-side profiler trace is your best option to get all the data you want and not miss any logins.

Make sure to include the TextData field to get the procs and...

You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking your I/O,...

If I'm not mistaken, Data Mirroring uses the Service Broker to transmit data over to the mirror. So everything is queued up as messages that are read into the mirror....

Try this from different workstations and from the server directly. Do you still get the same error?

What edition & version (including service packs) of SQL Server are you using?

If someone asked me about the accuracy in an interview, my response would be "I don't know. I've never needed GetDate() or related functions to be that precise. If and...