reset toolbox doesn't delete my components

Hi,

I am in the process of developing a custom component. During that time I went through many versions of my custom component, including various DLL names and signatures, different code etc.

The problem is that now I have old versions of my custom components stuck in the default settings of the toolbox. When I reset the toolbox, even if I manually deleted the old items, it appears again.

I tried to delete all the DLLs I previously copied to the SQL Server directories, and also uninstalled all the DLLs from GAC.

The result was that the new components didn't appear, and I don't have the option to choose them in the "choose items" menu, but they still appear on the toolbox.

It is not something I can't live with, but it's really annoying seeing old and irrelevant versions right in your face...

Please help :-)

I believe the toolbox enumeration is driven off the %ProgramFiles%\DTS\<ComponentType> folder, so if you delete the old versions from there and reset they should be removed from the toolbox.|||I don't have that folder... I tried deleting everything from the relevant sql server folder, but it didn't help.|||Sorry, what I meant was %ProgramFiles%\Microsoft SQL Server\90\DTS\<Component>. So to remove any Data Flow components, clean up C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents. For Tasks, clean up C:\Program Files\Microsoft SQL Server\90\DTS\Tasks etc.|||That's what I did to begin with... it still didn't help.

Representing a graph in TSQL

Hi!
I need to represent a graph in TSQL.
The graph is directed. It is essentially a number of trees which all have various (non-root) nodes in common with each other.
Any ideas or pointers would be most welcome :)
Thanks,
AngelosWithout knowing what your instructor covered in class, we can't even give you a good guess at how to do this. All three of the classic methods for representing graphs are easy to support in SQL, and many of the more avante-guard representations are easy too.

Talk with the instructor. It is still quite early in the session (at least most places). They should be willing to help you work this out.

-PatP