Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-29 : 22:44:28
|
Justin Barr writes "Good Sirs ,
I beleive in neat,efficient and tidy SQl databases..,so I wonder if you can help me with this...
I have a large SQL database which has been built up over the last couple of years.+- 5 in SQl Server. The no. of tables,stored procs,jobs and DTS packages are incredible...
Thing is there is so many tables, stored procs, jobs and DTS packages that are not needed or not accessed by our website, and I'd like to clean up and possibly store/delete these redundant items mentioned elsewhere...
Is there a possible way in finding out what tables, stored procs, and DTS packages are not used or accessed. And if so what the best way of cleaning up my database...
It would be great if you could help me...
All the best.
Just." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-09-05 : 04:57:09
|
| OK now this is a really old thread. But the mounties always get their man, and so here goes. [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5193[/url]PS - no luck with the dts packages using this method...--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 09/05/2002 04:58:47 |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-09-05 : 05:04:50
|
| Look at www.lockwoodtech.com, for a tool called SQLCLEAN |
|
|
|
|
|
|
|
|
Cleaning up tables,jobs,dts packages.....