March 17, 2008 at 1:18 am
I have done Oracle DBA, But new to Sql Server , User level knowledge is there, in my organization i got one inherited database from previous Developer he created database in that i see many tables with same name slight changes and almost same data it seems, i want to delete unnecessary tables, but i want to know which tables are not in use, in our application web site then i have to see currently running web site and all it pages but, i want to know any tool thats check accordingly my web pages it can reveal witch tables are used and witch tables are not used in my web application front office and back office, (Manually I can Handle), But if any tool is ready then please let me know
March 17, 2008 at 7:11 am
Take a look at the Profiler, under Tools in Enterprise Manager.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply