You may close the issue, but you failed to answer the question, why you needed procedure A to know if it was called by procedure B or called independently of...

There are also changes to any indexes that need to be logged in case of a rollback. In addition, when you are doing the delete, what else is going...

It would help to have the actual execution plan and the code. It may also help to have the DDL for the tables including indexes. Just from your...

Okay, Venkat, you have had several replies to your question as well as I asked of you. How about some feedback?

idrees.butt (2/6/2009)

---

I am interested in buying following books (all or some) from amazon (probably)

Title: Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization

Title: Inside Microsoft SQL Server 2005: T-SQL...

GilaMonster (2/6/2009)

---

Ask them to find out. Network security is their business and an...

So did my brother when the Enterprise went into dry dock. It was supposed to be for 6 months, ended up being 3 years. Then, when he should...

The more you remind me of what my brother said about the Navy, the more I'm glad I...

Grant Fritchey (2/6/2009)

---

Chris Morris (2/6/2009)

---

Grant Fritchey (2/6/2009)

---

Oh there are individuals, but the culture seems different. The Air Force bases were always so clean & orderly & mannered where as, except...

Grant Fritchey (2/6/2009)

---

Lynn Pettis (2/6/2009)

---

Being prior enlisted in the Air Force, I guess it depends on who you hang out around. I've met a few that would turn a...

Being prior enlisted in the Air Force, I guess it depends on who you hang out around. I've met a few that would turn a Marine "Air Force Blue".

Grant Fritchey (2/6/2009)

---

I speak a bit of Southern, some Jersey, some Brooklyn. I'm very fluent in Navy, but really, it's just English with the f-bomb inserted every three to four...

Nikhil (2/6/2009)

---

The database scheme consists of four tables:

Product(maker, model, type)

PC(code, model, speed, ram, hd, cd, price)

Laptop(code, model, speed, ram, hd, screen, price)

Printer(code, model, color, type, price)

The table "Product" includes information...

Should have asked this first, why does Procedure A need to know if it was called by Procedure B or independently of Procedure B?

I've used the sql_variant type once, in a TMR database used to evaluate data in other databases. I needed to be able to store data from other databases without...