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 12»»

Finding Jobs Expand / Collapse
Author
Message
Posted Wednesday, May 5, 2010 12:02 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 15, 2014 3:43 AM
Points: 117, Visits: 464
Comments posted to this topic are about the item Finding Jobs
Post #915829
Posted Wednesday, May 5, 2010 6:20 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:47 AM
Points: 199, Visits: 512
Nice Article! It's good to learn for new DBA's like me. Thanks for sharing.
Post #915990
Posted Wednesday, May 5, 2010 8:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 12:08 PM
Points: 1,414, Visits: 4,540
thx

going to have to try this to see how it works

edit: does this work with DTS packages? we have a lot of jobs that are DTS or SSIS packages and not just running stored procedures


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #916094
Posted Wednesday, May 5, 2010 9:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:48 PM
Points: 1,142, Visits: 2,687
Thanks for the article. I almost did read it because I have a job and am not looking.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #916166
Posted Wednesday, May 5, 2010 9:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:49 PM
Points: 389, Visits: 154
sysdepends is going to be deprecated in future releases.

While it runs perfectly on older editions, do not get addicted to it
Post #916222
Posted Wednesday, May 5, 2010 10:01 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
Nitya (5/5/2010)
sysdepends is going to be deprecated in future releases.

While it runs perfectly on older editions, do not get addicted to it



As will sysobjects be deprecated.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #916229
Posted Wednesday, May 5, 2010 10:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
Trey Staker (5/5/2010)
Thanks for the article. I almost did read it because I have a job and am not looking.



I thought the same thing when I first saw the title.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #916230
Posted Wednesday, May 5, 2010 10:03 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
tushkieeeee

Nice article.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #916233
Posted Wednesday, May 5, 2010 10:03 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 25, 2014 9:20 AM
Points: 80, Visits: 428
Try sys.dm_sql_referenced_entities or sys.dm_sql_referencing_entities instead. Otherwise it's a nice idea.

Oh wait, I just re-read and saw you were doing this for 2000. Didn't know anyone was still using 2000...


Francis
-----------------
SQLRanger.com
Post #916234
Posted Wednesday, May 5, 2010 10:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 16, 2013 7:19 AM
Points: 98, Visits: 226
The problem is not just the sysdepends is deprecated, it is not accurate.
Example:
create a table
create a procedure that selects from the table
drop the table (which deletes records in sysdepends)
create a table with the same name

The procedure still runs, still depends on the table, but no record in sysdepends

Even if they fixed that problem in 2005/2008 you still won't have tables referenced in dynamic SQL, etc..

It is not that hard to write some code to search syscomments (or sys.sql_modules)
(like the code in the article searching the job command field)

Of course it helps if your naming convention is such that it reduces false positives.
Post #916277
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse