SQL Server Forum Support Team

We are a support force in Microsoft SQL Server forums, striving to help individuals, developers and customers address their technical pains on SQL Server.

Our SQL Server Forum Support Team authored, collected and consolidated those common asked questions...

Date: 06/09/2011

By default, after installing Window7 operation, there are many powerful and handy little tools in...

Date: 05/26/2011

By default, if we create cascading Parameters, Reporting Service will force us to select one value...

Date: 05/26/2011

In Microsoft SQL Server Master Data Services (MDS), we can call the MDS web services, and the method...

Date: 05/03/2011

Generally, we can use the EntityMembersUpdate method from MDS web services to update members in MDS....

Date: 05/03/2011

SQL Server Master Data Services (MDS) is a new feature in SQL Server 2008 R2. It is the source of...

Date: 05/03/2011

Generally, using a parameterized query can filter data for a report dataset at the source. When...

Date: 05/03/2011

In Microsoft SQL Server Reporting Services (SSRS), you can use XML data source type to connect to...

Date: 04/27/2011

You can connect to a Windows SharePoint Services Lists Web Services, and use GetListItems method...

Date: 04/27/2011

The Walkthrough: Creating a ReportViewer Report shows how to create a simple table report in a...

Date: 04/27/2011

Question After SQL Server 2008 or 2008 R2 cluster setup, you may want to add new features that were...

Date: 04/19/2011

Question Sometimes, we get ‘SQL Server Setup cannot validate the service accounts’ in...

Date: 04/19/2011

Question In the SQL Server community, a typical question often raised is that how I shall apply a...

Date: 04/19/2011

Question Could SQL Server 2008 Express edition and SQL Server 2008 R2 Express edition be installed...

Date: 04/19/2011

Questions: How do I use the OLE Automation Stored Procedures to monitor the disk space? For example,...

Date: 04/19/2011

Summary In SQL Server, I want to assign a string value ‘1234’ to a decimal(5,2) variable...

Date: 04/19/2011

Question When I use SQL Command Text, there is a Parameters button in OLE DB Source. But now I want...

Date: 04/10/2011

Question In SQL Server, I use a CASE expression to return different values base on a...

Date: 04/10/2011

Question I want to get a total of certain group within a group footer of the Tablix, which has...

Date: 04/10/2011

Question There is a button "Change User" in Cube Browser, we can impersonate other user in "Security...

Date: 04/10/2011

Question When I query cube in my Cube Browser, suppose that the results are: Product MEASURES.A...

Date: 04/10/2011

Questions I could not connect to my SQL Server instance and I doubt that it is a Windows firewall...

Date: 04/10/2011

Symptom I have 2 decimal data fields (Field1 and Field2) in a dataset, and use the expression with...

Date: 02/28/2011

Question In Microsoft SQL Server Reporting Services (SSRS), you may encounter the error "The report...

Date: 02/28/2011

Question According to the MSDN document Passing a Report Parameter Within an URL, I could pass a...

Date: 02/28/2011

Question I have a local report with a long height; The problem is that there are two vertical scroll...

Date: 02/28/2011

Question I am using the ReportViewer control to show local reports in an ASPX page. The reports are...

Date: 02/28/2011

Question I have set both Interactive Size and Page Size to 8.5 inch in width and 11 inch in height....

Date: 02/27/2011

Question You design a SQL Server Integration Services (SSIS) package using Business Intelligence...

Date: 02/27/2011

Question I created several Drillthrough Actions in my cube. The build-in function for Drillthrough...

Date: 02/27/2011

Question I want to retrieve a large character-based output parameter with varchar(max)/nvarchar(max)...

Date: 02/27/2011

Question My stored procedure has a varchar(100)/nvarchar(100) output parameter, however it seems...

Date: 02/27/2011

Question I want to read image data from SQL Server with SQL Server Driver for PHP 2.0, and then save...

Date: 02/27/2011

Questions: I am trying to import the XML data into a database table in SQL Server 2008 using SQL...

Date: 02/27/2011

Question I have a CLR function with a decimal(18,2) return value. However, I find that the return...

Date: 02/27/2011

Question I want to connect to a 32-bit SQL Server using ODBC. And I use ODBC Data Source...

Date: 02/27/2011

Question I want to do a wildcard search using Full-Text Search. For example, I want to know the...

Date: 02/27/2011

For one-to-many currency conversion, you can download sample SSAS project to check how it works....

Date: 01/04/2011

In reporting Services security management, we often want the users to see only their folders. If...

Date: 01/03/2011

This topic describes how to request a digital certificate from a certificiate server(CA), or create...

Date: 01/02/2011

You could display a Subreport in Server report easily; however, you will get error message: Sub...

Date: 01/02/2011

The MSDN document https://msdn.microsoft.com/en-us/library/ms251784(v=VS.100).aspx shows a good demo...

Date: 01/02/2011

Question When using filters in a report, you will find the limitation of the condition "and/or" in...

Date: 12/21/2010

Question I want to display parameter prompts for my local report in reportviewer control, however it...

Date: 12/21/2010

Question How do I pass a multi-value parameter into a report with Reporting Services Web service...

Date: 12/21/2010

Question In my report, there is a single-selected parameter called rptParameter and it is used in my...

Date: 12/21/2010

Question Saying in Design mode, I have one report in a SSRS project and I would like to display...

Date: 12/21/2010

Summary I have installed 64-bit MSDASQL on my Windows Server 2003,...

Date: 12/20/2010

Question I want to run SQL Server service under a managed service account (MSA). How can I do it?...

Date: 12/20/2010

Next>