Thanks for the info.

x64. And I've learned something new today. I set the max memory on SQL to 5000mb, which seems to have halted the amount of memory SQL was using....

because SQL will eventually suck up all the memory and there won't be any free memory.

Yes, it was the data file. I found the table that grew by 11gb by going through each table one at a time using Toad. It was a...

Well I've been using both SP and queries. Probably 70/30 queries to SP. The more complex it is, the more likely I am to use a SP simply...

Yes I can say that.

Thanks. That did the job.

As I was trying to simplify the query for this post, I found the culprit. It is the case statement that is causing the time. Without the case...

I am not having any luck with this at all.

1. I can connect to the report manager. It shows all of the reports. I can look at...

So I have Builtin\users, Domain Users and Everyone with permissions on the 2008 SSRS and it still is not working. I am a domain admin and it doesn't work...

Elliot - When I am plugged in to the network at the office, it takes a couple of seconds to run the report. Tonight I'll let the reports run...

I think I realized that just about the same time you were typing it. I'm trying to get to the record in the application that had the lock to...

adams.squared (9/27/2010)

---

So on my client using SSMS I log in to the server using my Windows login. The SPID of the lock is the same as my login. ...

So on my client using SSMS I log in to the server using my Windows login. The SPID of the lock is the same as my login. I...

When I run SP_Lock under SA the SPID is 61. Under my Windows login it is 59. The DBID and the ObjID are the same. Below are...

tried that. under either my windows authorization or using SA, I get the same error.