none
Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools

    Question

  • I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

    Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

    1.  Show users the database tables and/or views

    2.  Run queries

    Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.

    Saturday, October 09, 2010 12:53 AM

Answers

  • SQL Server Management Studio 2008 is very feature rich. From developer perspective it has Intellisence built-in now. It does meet the 2 requirements that you have mentioned. It is just matter of getting used to the interface and the migration from Query Analyzer to SSMS should be smooth


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    • Marked as answer by Lucky. _ Wednesday, October 13, 2010 10:45 PM
    Saturday, October 09, 2010 4:03 AM

All replies

  • SQL Server Management Studio 2008 is very feature rich. From developer perspective it has Intellisence built-in now. It does meet the 2 requirements that you have mentioned. It is just matter of getting used to the interface and the migration from Query Analyzer to SSMS should be smooth


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    • Marked as answer by Lucky. _ Wednesday, October 13, 2010 10:45 PM
    Saturday, October 09, 2010 4:03 AM
  • Hi Lucky,

    I totally agree with Pradceep's answer. SSMS 2008 has Intellisence feature which when you right a query says  SELECT * FROM .. It will display a menu which has all the tables/views information in that specific database with which one is connected so its easy for every one to use.

    Run queries ofcourse it will do it as its developed to do that operations... :)

    HTH


    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++++++++++++++++++++++++++++++++++ Please mark "Propose As Answer" if my answer helped +++++++++++++++++++
    Saturday, October 09, 2010 5:21 AM