Of course, here is some rough code I threw together that may help you figure out what you need to do.

create table #Header (

HeaderID int,

...

Can you put together a sample set of tables (create statements), sample data (as insert statements so we can copy, paste, and execute to load the tables), and the expected...

VSTE -- Visual Studio Team Edition.

😎

rbarryyoung (8/5/2008)

---

Lynn Pettis (8/5/2008)I think, in this particular case, it has to do with the INFORMATION_SCHEMA views. I played with them in SQL Server 2000, and for those to...

rbarryyoung (8/5/2008)

---

Well, this works in the sense that...

jpowers (8/5/2008)

---

jim.powers (8/5/2008)

---

Personally, when I get to the point where I can retire, I have no plans of un-retiring. Technology does move far to fast and I feel like I'm...

Check the schedules. Make sure there aren't two schedules assigned to the maintenance jobs.

😎

Could you provide more detail? What would really help is if you could provide the DDL for the tables (create table statements) (or at least the key columns for...

Andras Belokosztolszki (8/5/2008)

---

One solution is to add the stored procedures to the master database, and add sp_ prefix to their names

(bad practise)

Another solution is to use a tool to...

Cost: $50.00 (USD)

Well worth the investment!

Edit: I bought it when SQL Server 2005 first came out. Comes with the x86, x64, and Itanium versions.

😎

jim.powers (8/5/2008)

---

Personally, when I get to the point where I can retire, I have no plans of un-retiring. Technology does move far to fast and I feel like I'm already...

Could be. It depends on the people. ...

LOL. I live in the banana belt. The north...

query sys.columns or INFORMATION_SCHEMA.COLUMNS. You will probably need to link in a few other tables or views as well to know what you are looking at.

😎

There may be a better way (ie without the subquery, set based) but here is something that at least works. If I get any more brilliant ideas, I'll post...