Post New Web Links

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

Posted By: Posted Date: October 08, 2010 Points: 0 Category :Sql Server

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

More Related Resource Links

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer

In my last column, I discussed MicrosoftÃÂ® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

What will happen with SSMS2005 and BIDS2005 after installing SQL Server 2008 client tools to a works

In 2009, after I installed VS 2008, then I installed SQL Server 2005 client tools. The SQL Server 2005 client-tools setup installed a VS 2005 for my BIDS. It seemed to me, with VS 2008 installed, installing SQL Server 2008 will install/add BIDS directly into the installed VS 2008. Am I right?

My questions are – what will happen with our old SQL 2000/2005 databases and BIDS2005 packages if I install SQL 2008 client tools at the same workstation with the existing SQL 2005 client tools. (Installing SSMS 2005
disabled SSEM 2000.)

Thanks,
Jeffrey

SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007

I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

Using SQL Server 2008 R2 client with Enterprise Library

All,

I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?

Thanks

Query on XML datatype in SQL Server 2008

Hi All, In table I have column with XML datatype. I can able to read the below XML tag. SET @Title = CAST(@XMLContent.query('data(root/chemicalName)') AS VARCHAR(50)) <root><chemicalName>Sulphuric acid</chemicalName></root> but how can I read (in SQL Server 2008) with multiple rows in it, and how to know the list of child nodes and data of it dynamically? <Root> <Row> < CurrencyCode>GBP</CurrencyCode> < CurrencyName>POUND (STERLING)</CurrencyName> </ Row> <Row> < CurrencyCode>INR</CurrencyCode> < CurrencyName>Rupee</CurrencyName> </ Row></

SQL Server 2008 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7. I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure. I'm not technical enough to know exactly where these files are or what they are named. I cannot proceed any further without correcting this issue. I'll include some of the shorter summary log files. I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary: Final result: Passed Exit code (Decimal): 0 Exit message: Passed Start time: &n

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2? The regular remove program does not have this option highlighted. I am trying use some of the advance option and learn something more and now ssms is useless. the discovery report tells me these are installed but I have no way of uninstalling. . I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version. Please help. I'd really appreciate it. " Sql Server 2008 Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008 Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008 Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008 Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

SQL server 2008 - Unable to tune a query with DTA

We are on:Verison: SQL 2008 [10.0.2531] on windows server 2008. Both are enterprise editions.When I highlight the query and right-click, then select Analyze Query in Database Engine Tuning Advisor, then click "Start Analysis", I get the following error in the "Message" column of "Progress" tab of DTA: Cannot initialize tuning. [.Net SqlClient Data Provider] If I click on this, it displays this message: "Cannot find either column 'msdb' or the user-defined function or aggregate 'msdb.dbo.fn_DTA_unquote_dbname', or the name is ambiguous. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count=0, current count=1. (Microsoft SQL Server Error: 4121)Please let me know if you guys have any ideas on this error. Thanks,Sam.

SQL server management studio 2008 freezes when running a query to Grid result

Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio 10.0.2531.0 Microsoft Analysis Services Client Tools 10.0.3798.0 Microsoft Data Access Components (MDAC) 6.1.7600.16385 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4952 Operating System 6.0.6001 regards, Pim

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All