Link to home
Start Free TrialLog in
Avatar of DMTechGrooup
DMTechGrooupFlag for United States of America

asked on

MSSQL 3rd Part Admin tools - Capture Query, list all indexes, FKeys, etc.

We use an ERP Program that is going to a major upgrade and part of that is having to find custom triggers, indexes, FKeys, etc and knowing what is there and what we might need to remove and re-add, etc.

Also the reporting uses QRP and unlike SSRS or Crystal there's no way to see what the query consist of and we would like to capture that query.

We have used SQL Profiler, which I am not very good at.. so we were wondering if there was any 3rd part programs that might do it all or most etc.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DMTechGrooup

ASKER

Thanks