Finding Jobs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tushar Kanti » Finding Jobs

16 posts, Page 1 of 2

1 2 »»

Finding Jobs

Rate Topic

Display Mode

Topic Options

Author

Message

tushkieeeee

Posted Wednesday, May 05, 2010 12:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 06, 2013 6:54 AM
Points: 103, Visits: 411

Comments posted to this topic are about the item Finding Jobs

Post #915829

sqlusers

Posted Wednesday, May 05, 2010 6:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 6:13 AM
Points: 196, Visits: 467

Nice Article! It's good to learn for new DBA's like me. Thanks for sharing.

Post #915990

alen teplitsky

Posted Wednesday, May 05, 2010 8:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411, Visits: 4,517

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

Trey Staker

Posted Wednesday, May 05, 2010 9:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 1,380, Visits: 2,636

Thanks for the article. I almost did read it because I have a job and am not looking. w00t

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Post #916166

Nitya

Posted Wednesday, May 05, 2010 9:54 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 2:54 PM
Points: 389, Visits: 141

sysdepends is going to be deprecated in future releases.

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

Post #916222

SQLRNNR

Posted Wednesday, May 05, 2010 10:01 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,851, Visits: 12,437

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 2008

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

SQLRNNR

Posted Wednesday, May 05, 2010 10:02 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,851, Visits: 12,437

Trey Staker (5/5/2010)

Thanks for the article. I almost did read it because I have a job and am not looking. w00t

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

Post #916230

SQLRNNR

Posted Wednesday, May 05, 2010 10:03 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 18,851, Visits: 12,437

tushkieeeee

Nice article.

Post #916233

Francis Apel

Posted Wednesday, May 05, 2010 10:03 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 10:08 AM
Points: 62, Visits: 245

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... Wink

Francis

Post #916234

steven.malone

Posted Wednesday, May 05, 2010 10:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 6:58 AM
Points: 96, Visits: 210

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 »

16 posts, Page 1 of 2

1 2 »»

Permissions