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.
View Complete Post