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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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