By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Unused Objects

P: n/a
SB
Hi,

Is anyone aware of any freeware/shareware tools that can assist in
identifying unused objects in a database? I have inhertited a database from
a previous developer, and there seems to be a lot of unused queries and code
in the database. I know of Total Access Analyser from FMS, but my boss won't
agree to the purchase due to the current conversion rate from $USD to $AUD,
making this about $500.00 Australian to purchase, which he says is too much
for a 'once-off' job. Any suggestions would be appreciated.

SB

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
TC
One extremely ugly & low-tech solution (if you can't buy a product, or get
access to one, or write one yourself):

Find a query (say) that you think is unused. Rename it by adding a "zz"
prefix (for example). Run some functions of the system. If it works ok for a
week or two, take a backup copy of the database, then delete all zz* items.

With code, say there is an unused procedure. Bracket that procedure with #IF
TRUE THEN at the top, and #ENDIF at the bottom. (Don't forget the crosshatch
at the start of those statements). Then do a recompile all. If it compiles
ok, the bracketed-out code is almost certainly not used, so take a backup
then delete it.

Ugly, but...

HTH,
TC
"SB" <sw************@bigpond.net.au> wrote in message
news:ZT*********************@news-server.bigpond.net.au...
Hi,

Is anyone aware of any freeware/shareware tools that can assist in
identifying unused objects in a database? I have inhertited a database from a previous developer, and there seems to be a lot of unused queries and code in the database. I know of Total Access Analyser from FMS, but my boss won't agree to the purchase due to the current conversion rate from $USD to $AUD, making this about $500.00 Australian to purchase, which he says is too much for a 'once-off' job. Any suggestions would be appreciated.

SB

Nov 12 '05 #2

P: n/a
TC
Further to this:

Say you're on AUS$50k pa. At that rate, you'll clock up AUS$500 in less than
a week. So does it make sense to work on this for a fortnight (say), or
should your boss take the *cheaper* route, & just shell out for the product!

TC
"TC" <a@b.c.d> wrote in message news:1066626685.622899@teuthos...
One extremely ugly & low-tech solution (if you can't buy a product, or get
access to one, or write one yourself):

Find a query (say) that you think is unused. Rename it by adding a "zz"
prefix (for example). Run some functions of the system. If it works ok for a week or two, take a backup copy of the database, then delete all zz* items.
With code, say there is an unused procedure. Bracket that procedure with #IF TRUE THEN at the top, and #ENDIF at the bottom. (Don't forget the crosshatch at the start of those statements). Then do a recompile all. If it compiles
ok, the bracketed-out code is almost certainly not used, so take a backup
then delete it.

Ugly, but...

HTH,
TC
"SB" <sw************@bigpond.net.au> wrote in message
news:ZT*********************@news-server.bigpond.net.au...
Hi,

Is anyone aware of any freeware/shareware tools that can assist in
identifying unused objects in a database? I have inhertited a database

from
a previous developer, and there seems to be a lot of unused queries and

code
in the database. I know of Total Access Analyser from FMS, but my boss

won't
agree to the purchase due to the current conversion rate from $USD to

$AUD,
making this about $500.00 Australian to purchase, which he says is too

much
for a 'once-off' job. Any suggestions would be appreciated.

SB


Nov 12 '05 #3

P: n/a
Work out your hourly rate, clculate how long it will take you by hand.
Multiply one by the other and if it doesn't come to more than $500 then yoo
need a new job or the task is too simple for words.

IOWs, your boss is almost certainly being very shortsighted here, rustle up
some figures to prove to him that it is worthwhile for this one off job.

Terry

"SB" <sw************@bigpond.net.au> wrote in message
news:ZT*********************@news-server.bigpond.net.au...
Hi,

Is anyone aware of any freeware/shareware tools that can assist in
identifying unused objects in a database? I have inhertited a database from a previous developer, and there seems to be a lot of unused queries and code in the database. I know of Total Access Analyser from FMS, but my boss won't agree to the purchase due to the current conversion rate from $USD to $AUD, making this about $500.00 Australian to purchase, which he says is too much for a 'once-off' job. Any suggestions would be appreciated.

SB

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.