January 9, 2006 at 3:04 pm
How do you go through all the DTS on a SQL 2000 server and list the the connections under "Disconnected Edit" using SQL DMO? I want to see what DTS are using a particular server in their connections.
There has to be a way!
January 10, 2006 at 3:49 pm
Take a look at my script over here
http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=40
--------------------
Colt 45 - the original point and click interface
January 11, 2006 at 10:51 am
Phil,
Thanks for this, this does exactly what I have been looking for. Does this work against 2005? Do you have any plans on writting a new version that will if it does not?
January 11, 2006 at 1:08 pm
Thank you!!! That was what I was looking for.
Carol
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply