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 |
|
rythm123us
Starting Member
27 Posts |
 Posted - 2005-09-20 : 09:42:27
|
| I was wondering if there was a way to log the the Tables, Views and Stored Procedures being used on a Database. Because I was thinking of deleteing a few things and I was not sure if they were being used. Any thoughts... |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-20 : 09:45:24
|
| I think running the Profiler is the only way until you have proper document having these informationsMadhivananFailing to plan is Planning to fail |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-20 : 09:53:19
|
| well if you have a table with hundreds of thousands or millions etc... records and you have a field that has been populated twice....when I was just working on back office stuff for a medium sized firm and this is horrible practice but a little bit of fun if you can get away with it, I would rename something and if no one came screaming or there were no trouble tickets I would put it on my local sql server just in case and drop it from production after a few weeks.in the same envrionment, I coded a lot of ASP and when I deployed something new I was skeptical about I would have it email me the first time it was used.otherwise profiler is the way to go.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
|
|
|
Checking Tables, Views and Stored Procedure Usage