Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Fixing SysDepends Expand / Collapse
Author
Message
Posted Wednesday, September 21, 2005 3:23 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/fixingsysdepends.asp






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #222403
Posted Thursday, September 22, 2005 12:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Cheers 4 that - looks very useful!


Post #222477
Posted Thursday, September 22, 2005 2:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 11, 2012 1:09 AM
Points: 8, Visits: 15

I receive an error message just before the image appears that will (hopefully) display the dependencies.

Here's what's logged to the event viewer:

These are the technical details about an error that occurred.

If you are need assistance with this you can phone or email us:

phone: 1 866 733 4283 (toll free USA and Canada)

phone: +44 (0)870 160 0037 (rest of the world)

email: support@red-gate.com

exception name: System.Net.WebException

description: The remote server returned an error: (407) Proxy Authentication Required.

handler: user interface

------------------------------ STACK TRACE BEGINS ------------------------------

at System.Net.HttpWebRequest.CheckFinalStatus()

at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)

at System.Net.HttpWebRequest.GetResponse()

at System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials credentials)

at System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials)

at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)

at System.Xml.Schema.DtdParser.ParseDocTypeDecl()

at System.Xml.Schema.DtdParser.Parse()

at System.Xml.XmlTextReader.ParseDtd(XmlScanner scanner)

at System.Xml.XmlTextReader.ParseTag()

at System.Xml.XmlTextReader.ParseRoot()

at System.Xml.XmlTextReader.Read()

at System.Xml.XmlValidatingReader.ReadWithCollectTextToken()

at System.Xml.XmlValidatingReader.Read()

at System.Xml.XmlLoader.LoadCurrentNode()

at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)

at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)

at System.Xml.XmlDocument.Load(XmlReader reader)

at System.Xml.XmlDocument.Load(String filename)

at _16._1(String )

at _28._1(String )

at _26._3(Object , EventArgs )

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

------------------------------ STACK TRACE ENDS ------------------------------

Post #222497
Posted Thursday, September 22, 2005 5:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 16, 2013 12:25 AM
Points: 182, Visits: 7
A nice utility which would be even nicer if it could filter on object type/object name prefix or suffix. This would make it easier to handle databases with a large number of objects.





Brgds

Jonas
Post #222545
Posted Thursday, September 22, 2005 6:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 24, 2006 1:59 PM
Points: 25, Visits: 1
Looks like a useful utility. It did miss one area of dependicies that matter to my job that get over looked by the developers when they make changes to table structures, DTS packages.
Post #222567
Posted Thursday, September 22, 2005 8:49 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
This shows good potential, however I think the article doesn't relate to the application as it doesn't seem to fix the sysdepends problems in any way. I think the title is slightly misleading... However again, this is something that I could really use in real life.
Post #222654
Posted Thursday, September 22, 2005 9:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 20, 2011 10:51 AM
Points: 272, Visits: 45

Still evaluating, but certainly looks promising. 

Wish List:

Ability to rearrange objects.

Sent to file or printer.

 

 

Post #222709
Posted Thursday, September 22, 2005 9:56 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 8:03 PM
Points: 6,266, Visits: 2,027

Title of the article is not appropriate. How does this fixes sysdepends again?

[Edit] : Oops I see Remi already mentioned

 




* Noel
Post #222729
Posted Thursday, September 22, 2005 10:12 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
That would be the real turn on to buy a product.

I guess it could be done. If you were to re-run each script with alter proc... but I never got the courage to run that on production .
Post #222739
Posted Thursday, September 22, 2005 10:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 14, 2010 11:39 AM
Points: 56, Visits: 18

I'd like to be able to tell it what object to start with.

Need to be able to print it.

need to be able to zoom-all and have it centered. (need to be able to move objects so the zoom works better -- kind of like the diagram tool in Enterprise Manager).

Post #222749
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse