Answer Questions

• xshua Permit user to select columns for a report: why not use Dynamic SQL?

  I certainly have read lots of negative comments about using Dynamic SQL. And I have read some of the excellent web pages on the subject, such as http://www.sommarskog.se/dynamic_sql.html I have learned much from those discussions. But I still find myself faced with a problem for which Dynamic SQL seems like the only reasonable solution: letting a user select the columns to include in a report, and the sort order for the output data. In the application of concern, there are maybe seven columns that one might want to have in a report. If the user can choose any combination of these seven columns, and the order in which they are displayed (as well as the SORT order), it would be necessary to write something like 7! (7-factorial = ...Show All

• sowjanya SQL SERVER 2005 Desktop Engine Version avaliable?

  hi dear developers; i just finished my program and i am making a setup for it but the db is MSSQL SERVER 2005. the home users how will they use sql server 2005 is there any thing like sql server 2000 desktop engine something like that... shortly the user don't have to know sql server and settings of it so how will we do it thank you very much... In SQL Server 2005, we have SQL Express, which is similar to MSDE in 2000, but includes more functionality. Take a look at this page for more info: http://www.microsoft.com/sql/editions/express/default.mspx Thanks, Sam Lester (MSFT) SQL 2000 DB's can certainly be used in SQL Server 2005. As for consuming Express in your application install, I don't know ...Show All

• cbpd86 Cannot find support for Distinct Count Measures in oledb.h

  Hi All, I was getting following errors while creating a subcube: [ 1] MicrosoftR OLE DB Provider for Analysis : Formula error - global cubes do not support distinct count measures. On investigating, i found that this measure is not defined in oledb.h present in my local machine: \Program Files\Microsoft Visual Studio .NET 2003\Vc7\PlatformSDK\Include\oledb.h #define MDMEASURE_AGGR_UNKNOWN 0x00 #define MDMEASURE_AGGR_SUM 0x01 #define MDMEASURE_AGGR_COUNT 0x02 #define MDMEASURE_AGGR_MIN 0x03 #define MDMEASURE_AGGR_MAX 0x04 #define MDMEASURE_AGGR_AVG 0x05 #define MDMEASURE_AGGR_VAR 0x06 #define MDMEASURE_AGGR_STD 0x07 #define MDMEASURE_AGGR_CALCULATED 0x7f The value i am getting back as m_measure_aggregator ...Show All

• Sergei Dorogin SSIS (Integration Services) Transfer SQL Server Objects Task: This task can not participate in a transaction

  In short, does the “Transfer SQL Server Objects Task” support distributed transactions In trying to use a “Transfer SQL Server Objects Task” in a container using a transaction on the container. The task is set to support the transaction. It is setup to copy table data from several tables from a non-domain server (sql server 2000) to a domain-based server (sql server 2005). I get an error stating, “This task can not participate in a transaction”. I am wondering if it means exactly what it says – this task in SSIS can’t participate at all. Or does it mean that it won’t in this scenario for some reason. I attempted a simple copy of data from mssql 2005 to mssql 2005 (same server) and the task still failed). MSDTC appears to be runn ...Show All

• clint 2 Can a SQL Server Express talk with other SQL Server Express in the same network?

  Hi There is a service from SQL Server 2005 that "listens" to the network, if the network is down, all data gets saved within the local instance of the SQL server 2005. And when the network becomes available, the local instance of the sql server will automatically "feed" the local records to the central SQL server 2005. What is that feature called It sounds like you're talking about Service Broker, but Service Broker doesn't support communication between two Express instances. Service Broker communication between SQL instances must include a paid edition somewhere in the message chain. I'm not aware of any other tools that support the type of communication you've describe. Mike Mike,th ...Show All

• Rodrigo Acosta "with" keyword - access only one time?

  i have a very silly problem .. following code does not work: with foo as ( SELECT * FROM table) select * from foo select * from foo the second select statement throws an error, that the foo object is invalid. can i access the "foo" object only once if yes, why i tried to script foo, foo1, foo2 as (SELECT * FROM table) and then the error would be "foo2" is not a valid object. any suggestions but why can't i access the object only once i know, that if i want to have 3 aliases, that i have to write: with foo as (select * from table), foo1 as (select * from table), foo2 as (select * from table) Because WITH is a construct of the SELECT statement in your case you have 2 SELECT statements and so you w ...Show All

• Leandro Rodrigues Can't run Business Intelligence Development Studio

  All, I've installed SQL Express with advanced services and the BIDS software from the SQL Toolkit using the vs_setup.msi extracted from the toolkit installer (Why not include it in the advanced services ). Now I'm trying to start BIDS and am asked to log into the Report Server. I use my username and password for ASPNET. The login fails saying that the web application is not available on the web server and to look in the application event log for more information. There are a bunch of errors listed (and more every 30 seconds are so). The error message is: aspnet_wp.exe could not be launched because the username and/or password supplied in the processModel section of the config file are invalid. Also, when I start Visual Web D ...Show All

• Mateusz Rajca Report listing

  Hi, does anyone know what is the mechanism behind the display order of reports in http://<server>/ReportServer For example, how can I modify the sorting order of report listing from ascending alphabetical to descending alphabetical order Thanks! ...Show All

• Stubey Filter Expression in Visual Studio

  Guys, I am using Visual Studio to browse a cube. In the cube browser do not understand the difference between the Filter Expression area and the "Drop Filter Fields Here" area. As far as I can tell, they should do exactly the same thing. However I have a situation where they do not. I am using the Tutorial, and am browsing variabes "Internet sales -sales amount" and "Sales amount quota". If I use the "Drop Filter Fields Here" area and restrict to Fiscal Year 2004 I get the correct value in both measures. If I use the Filter Expression area to do the same restriction I get the correct value for "Internet sales -sales amount" but the "Sales amount quota". shows a value represe ...Show All

• jiao How to grant rights for the anonymous IIS web user IUSR_.. to execute scalar function in assembly

  Dear all, Basically I want to set chain up the rights so that the anonymous web user IUSR_ .. can execute the new .NET subs, functions etc in the assembly , just as the anonymous web user can execute Stored Procedures when granted. In this way, it should be possible to call the .NET assembly just as classic stored procedures from ASP/ASP.NET. I have written a .NET function which I can successfully execute if I log on to the database as an administrator by sending this T-SQL query; it returns the result of a given string: select dbo.CLRHTMLString('abc') The scenario is now to try to grant access to this assembly for a different role (webuser), which the classic IUSR_MYSERVERNAME is a login of, so that I can call the .NET Assembly when I a ...Show All

• KrisMcg01 ADO Connection Pooling Error: "The client was unable to reuse a session with ..."

  Hello, We are running SQL2K5 and have a Web server with a family of sites all sharing an identical connection string to enable ADO connection pooling between them. Today for about 20 minutes we had several (all ) connections from one site that uses a specific DB get a connection reuse error which showed in out SQL logs: DESCRIPTION: The client was unable to reuse a session with SPID #, which had been reset for conection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. We also have SQL Server slowdown and log in problems from other applications that seemed a symptom of this, or some third unknown cause. Note, the # means the ...Show All

• ackermsb Is SQL Server supported in a VMWare environment

  I have looked all over the MS site and can find very little information regarding SQL Server's support for the VMWare environment.  Based on other information that I have obtained on other forums and web-site it looks like it is not supported by Microsoft, but I would like the company line if possible. Does any one know for sure and can point me to a URL   Thanks. We don't explitly call out VMWare but it is not listed as a supported platform in any of the docs. Euan, Do you have any links to Microsoft documentation I can pass on to a project manager I have been told that we will be using x445 with vmware to install our dev, stage, and production SQL instances on. Thanks, John Is t ...Show All

• nomer Column compression

  Hi, I was looking for a column compression functionality in SQL Server Compact and it seems that it doesn't exist (maybe I'm wrong ). I wonder if the SQL Server Team plan to implement column compression and if yes, when can we expect it Thank you for your help! There is compression functionality for SQL Server 2005 (http://www.codeproject.com/cs/database/blob_compress.asp ). The problem with SQL Server CE is that it does not support stored procedures and you will not be able to use this functionality. If you don't need to update the LOBs in your mobile device you can compress them in SQL Server, replicate them and decompress them at presentation time... but to answer your question we (the SQLCo ...Show All

• Helio D cannot create jobs on x64

  Hi all, Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) on a win2003 x64 server and encountered the following problems: 1) Could not create jobs Getting Error: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent. JobObjectKey '. (Microsoft.SqlServer.Smo) - Tried several different job types, always same result. - Installing SP1 does not help. - Installing with or without Integration Service does not help. Any help is highly appreciated TIA Dan No express installation before. TIA acki Thanks (acki4711) for the info! ...Show All

• Rocinante8 accessing SQL Server Compact Edition from VBA

  Is it possible to connect to SQL Server Compact Edition with Visual Basic for Application I want to connect to *.sdf file from MS Access. Thanks. I also suspected that, just was not sure is there OLEDB provider version for desktops, and how to access it. Just foud that information in one of the mahdi posts Dim cnx As ADODB.Connection Set cnx = New ADODB.Connection cnx.ConnectionString = "Provider='Microsoft.SQLSERVER.MOBILE.OLEDB.3.0.';Data Source='c:\\B.sdf';" cnx.Open I suppose you can do it using OLEDB if VBA allows you to use COM objects (which you should know better as I've never used VBA). ...Show All