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.
SQL Server Community FAQs eBook download
Our SQL Server Forum Support Team authored, collected and consolidated those common asked questions...
Date: 06/09/2011
Walkthrough: Integrating your SQL Server Reporting Services report into Windows 7 Sidebar Gadget
By default, after installing Window7 operation, there are many powerful and handy little tools in...
Date: 05/26/2011
Walkthrough: Implement Optional Cascading Parameters with "" in Reporting Services
By default, if we create cascading Parameters, Reporting Service will force us to select one value...
Date: 05/26/2011
FAQ: How do I send SOAP message to MDS web services to create EntityMembers with attributes other than Name and Code?
In Microsoft SQL Server Master Data Services (MDS), we can call the MDS web services, and the method...
Date: 05/03/2011
Walkthrough: Update members in SQL Server Master Data Service using MDS API
Generally, we can use the EntityMembersUpdate method from MDS web services to update members in MDS....
Date: 05/03/2011
Walkthrough: How to list models from SQL Server Master Data Services in a SQL Server Reporting Services (SSRS) report
SQL Server Master Data Services (MDS) is a new feature in SQL Server 2008 R2. It is the source of...
Date: 05/03/2011
Walkthrough: Control Dataset Query Dynamically based on SSRS Report Parameters
Generally, using a parameterized query can filter data for a report dataset at the source. When...
Date: 05/03/2011
Walkthrough: How to change XML data for embedded XML document in a SQL Server Reporting Services (SSRS) report
In Microsoft SQL Server Reporting Services (SSRS), you can use XML data source type to connect to...
Date: 04/27/2011
Walkthrough: How to get distinct values of a column of a SharePoint list using SQL Server Reporting Services
You can connect to a Windows SharePoint Services Lists Web Services, and use GetListItems method...
Date: 04/27/2011
Walkthrough: Assign Dataset Dynamically Created in Code to your local report with ReportViewer
The Walkthrough: Creating a ReportViewer Report shows how to create a simple table report in a...
Date: 04/27/2011
Forum FAQ: Why do I get ‘Rule “Existing clustered or clustered-prepared instance” failed’ error while adding new features to an existing instance of SQL Server Failover Cluster?
Question After SQL Server 2008 or 2008 R2 cluster setup, you may want to add new features that were...
Date: 04/19/2011
Forum FAQ: How do I resolve ‘SQL Server Setup cannot valid the service accounts’ error message during the setup?
Question Sometimes, we get ‘SQL Server Setup cannot validate the service accounts’ in...
Date: 04/19/2011
Forum FAQ: How do I apply a service pack for an instance of SQL Server 2005 Express Edition or SQL Server 2008 Express Edition?
Question In the SQL Server community, a typical question often raised is that how I shall apply a...
Date: 04/19/2011
Forum FAQ: Could SQL Server 2008 Express edition and SQL Server 2008 R2 Express edition be installed side by side with SQL Server 2005 Express?
Question Could SQL Server 2008 Express edition and SQL Server 2008 R2 Express edition be installed...
Date: 04/19/2011
Forum FAQ: How do I use the OLE Automation Stored Procedures to monitor the disk space?
Questions: How do I use the OLE Automation Stored Procedures to monitor the disk space? For example,...
Date: 04/19/2011
Forum FAQ: Why do I get a ‘Arithmetic overflow’ error when assigning ‘1234’ to a decimal(5,2) variable?
Summary In SQL Server, I want to assign a string value ‘1234’ to a decimal(5,2) variable...
Date: 04/19/2011
Forum FAQ: How do I use parameters in an SSIS ADO NET source?
Question When I use SQL Command Text, there is a Parameters button in OLE DB Source. But now I want...
Date: 04/10/2011
Forum FAQ: Why do I get a 'conversion failed' error when using the CASE expression?
Question In SQL Server, I use a CASE expression to return different values base on a...
Date: 04/10/2011
Forum FAQ: How do I get group total in Group Footer with PageBreak in SQL Server Reporting Services?
Question I want to get a total of certain group within a group footer of the Tablix, which has...
Date: 04/10/2011
Forum FAQ: How do I impersonate another user to test the MDX query in SSMS?
Question There is a button "Change User" in Cube Browser, we can impersonate other user in "Security...
Date: 04/10/2011
Forum FAQ: How do I force the [All] member to return the total of members?
Question When I query cube in my Cube Browser, suppose that the results are: Product MEASURES.A...
Date: 04/10/2011
Forum FAQ: How do I configure Windows Firewall to allow remote connections using TCP/IP protocol for SQL Server?
Questions I could not connect to my SQL Server instance and I doubt that it is a Windows firewall...
Date: 04/10/2011
FAQ: Why does the “Attempted to divide by zero” error still happen?
Symptom I have 2 decimal data fields (Field1 and Field2) in a dataset, and use the expression with...
Date: 02/28/2011
FAQ: How do I solve the issue - The configuration file contains an element that is not valid?
Question In Microsoft SQL Server Reporting Services (SSRS), you may encounter the error "The report...
Date: 02/28/2011
FAQ: How do I pass a multi-value parameter within a URL?
Question According to the MSDN document Passing a Report Parameter Within an URL, I could pass a...
Date: 02/28/2011
FAQ: How do I keep only one vertical scroll bar in local report?
Question I have a local report with a long height; The problem is that there are two vertical scroll...
Date: 02/28/2011
FAQ: How do I Hide Export Options with Local Report?
Question I am using the ReportViewer control to show local reports in an ASPX page. The reports are...
Date: 02/28/2011
FAQ: How do I get the same page number in web page and PDF?
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
FAQ: How do I refresh the layout information of a SQL Server Integration Services (SSIS) package that is modified programmatically?
Question You design a SQL Server Integration Services (SSIS) package using Business Intelligence...
Date: 02/27/2011
FAQ: How do I Implement Conditional Security setting for Drill-Through Actions?
Question I created several Drillthrough Actions in my cube. The build-in function for Drillthrough...
Date: 02/27/2011
FAQ: How do I retrieve varchar(max)/nvarchar(max) OUTPUT parameters from a SQL Server stored procedure with SQL Server Driver for PHP?
Question I want to retrieve a large character-based output parameter with varchar(max)/nvarchar(max)...
Date: 02/27/2011
FAQ: How do I retrieve a short length varchar/nvarchar OUTPUT parameter from a SQL Server stored procedure with SQL Server Driver for PHP?
Question My stored procedure has a varchar(100)/nvarchar(100) output parameter, however it seems...
Date: 02/27/2011
FAQ: How do I read an image data and save it into a file with SQL Server Driver for PHP?
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
FAQ: How do I import the XML file with the Cyrillic alphabets into a table using SQL XML 4.0?
Questions: I am trying to import the XML data into a database table in SQL Server 2008 using SQL...
Date: 02/27/2011
FAQ: How can I specify the precision and scale values of the decimal/numeric return value when deploying a CLR function in Visual Studio?
Question I have a CLR function with a decimal(18,2) return value. However, I find that the return...
Date: 02/27/2011
FAQ: How do I connect to a 32-bit SQL Server instance with ODBC in my 64-bit Windows OS?
Question I want to connect to a 32-bit SQL Server using ODBC. And I use ODBC Data Source...
Date: 02/27/2011
FAQ: How can I perform wildcard searches in Full-Text Search?
Question I want to do a wildcard search using Full-Text Search. For example, I want to know the...
Date: 02/27/2011
Walkthrough: Implement many-to-many currency conversion in an Analysis Services solution
For one-to-many currency conversion, you can download sample SSAS project to check how it works....
Date: 01/04/2011
Walkthrough: Restrict the users to see only their folders via Reporting Services web services
In reporting Services security management, we often want the users to see only their folders. If...
Date: 01/03/2011
Walkthrough: Request a Digital Certificate from Certificate Server or create a testing Digital Certificate to sign a Package
This topic describes how to request a digital certificate from a certificiate server(CA), or create...
Date: 01/02/2011
Walkthrough: Add a Subreport in local report in ReportViewer
You could display a Subreport in Server report easily; however, you will get error message: Sub...
Date: 01/02/2011
Walkthrough: Working ReportViewer with a complex Business Object with a nested generic list type property as data source for local reports
The MSDN document https://msdn.microsoft.com/en-us/library/ms251784(v=VS.100).aspx shows a good demo...
Date: 01/02/2011
FAQ: How do I implement OR logic or complicated logics for filters in a SSRS report?
Question When using filters in a report, you will find the limitation of the condition "and/or" in...
Date: 12/21/2010
FAQ: HOW do I work Parameters with a local report?
Question I want to display parameter prompts for my local report in reportviewer control, however it...
Date: 12/21/2010
FAQ: How do I pass a multi-value parameter into a report with SQL Server Reporting Services (SSRS) Web Services API?
Question How do I pass a multi-value parameter into a report with Reporting Services Web service...
Date: 12/21/2010
FAQ: How do I pass a multi-value parameter to a dataset while using LIKE operator in the WHERE clause?
Question In my report, there is a single-selected parameter called rptParameter and it is used in my...
Date: 12/21/2010
FAQ: How do I preview a Subreport which is in another SSRS project?
Question Saying in Design mode, I have one report in a SSRS project and I would like to display...
Date: 12/21/2010
FAQ: Why cannot 64-bit MSDASQL access a .csv text file?
Summary I have installed 64-bit MSDASQL on my Windows Server 2003,...
Date: 12/20/2010
FAQ: How do I run SQL Server service under a managed service account (MSA)?
Question I want to run SQL Server service under a managed service account (MSA). How can I do it?...
Date: 12/20/2010