Hi guys I was not sure where to post this thread and thought this wud be OK.. Actually we have a testing team in our department where they test all stored procs and views etc, right now they are doing tht through Query Analyser. I am eager to know if there is any third party tools so that we can test all sql server related things just automatically though they dont have any knowledge of SQL server. Any suggestions regarding will be appreciated. Thanks! "He laughs best who laughs last"
What kind of testing you want to perform? Using Query Analyzer you can parse the relevant query or get execution plan and what more you want. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Agree with Satya. Do they want to test or are they looking for a more feature-rich tool to develop. Anyway, see if you find something usefule here:http://www.quest.com/sql_server/index.asp Especiallyhttp://www.quest.com/toad_for_sql_server/index.asp might be of interest to you. It's freeware, but requires new-installation every 60 days. You might also want to have a look at the software tools section here on the site. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)