In Management Studio, check out View, Template Explorer. Scroll down & find Stored Procedures and the "Create Stored Procedure (New Menu)" script. Edit that and the next time someone...

YAY!

Now if only people will read and follow the advice here.

Well done. Very nicely laid out and explained.

RBarryYoung (6/12/2009)

---

Good catch Bruce. I had suspect some sleight of hand from either the OP or the Client code, but I missed the codegen reference.

Does anyone know of any...

Jeffrey Williams (6/11/2009)

---

Grant Fritchey (6/11/2009)

---

You will see contention between these two processes.

I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior...

Nope.

This is a side-by-side test between Profiler & server-side traces by Linchi Shea. The difference is not to be sneezed at.

When the Profiler GUI runs, it attaches a memory latch...

You will see contention between these two processes.

I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running backups.

vaxn8r (6/11/2009)

---

Thanx !! I never can get a grip on the whole licensing model of m$, but I believe if we were already licensed for vs2008 we could move...

No, I'm sorry. I didn't mean upgrade to SQL Server 2008. I meant upgrade to the GDR. I don't think there's any cost associated there. The functionality improvements in the...

The GDR is for 2008, but it changes the tool pretty radically in terms of deployment. It works great with 2005. I'd go for it if I were you.

I just...

Yeah, I'd make sure you've got the SP for VS installed, but also, I'd strongly recommend getting the GDR version, which I think also has a service pack. It eliminates...

Without knowing what your query is doing and what your structure looks like, it's just not possible to answer this question.

If you can, please post the query, the actual execution...

Well, you can also see if a lock has an outstanding convert request inside sys.dm_tran_locks. That's an indication of lock escalation. Once the lock is escelated though, you won't see...

I'd use a server-side trace. If you're unsure how to put them together, you can use Profiler to build the scripts for you after you use the GUI to define...

I have to agree with Hans here. You may need to maintain logic in more than one location simply because you can't have a single solution for all problems. As...

You're going to have to implement a code solution, not try to control locking. Here's a rough outline of an approach. You add two columns, call them InUse and UserID...