Showing posts with label including. Show all posts
Showing posts with label including. Show all posts

Monday, March 26, 2012

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.

Saturday, February 25, 2012

Repost: Polling the network for SQL servers, including named instances

Hi group,
I am trying to get a list of SQL Server installations running on the
network. I tried to use sqlcmd -L (or osql -L). However, when I do this
from my box the named instances do not show up, whereas when it is run from
a server box those instances do get listed.
What is required to make the command return the full list? Is there other
(simple) way to do it?
Thanks.
QuentinHi Quentin
Check out SQLPing or SQLRecon at
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
John
"Quentin Ran" wrote:
> Hi group,
> I am trying to get a list of SQL Server installations running on the
> network. I tried to use sqlcmd -L (or osql -L). However, when I do this
> from my box the named instances do not show up, whereas when it is run from
> a server box those instances do get listed.
> What is required to make the command return the full list? Is there other
> (simple) way to do it?
> Thanks.
> Quentin
>
>