Answer Questions

• Lucian Bargaoanu Problem with Totals with calculated cells

  Hello I have a problem with totals I have the following dimension -Turnover            700 ----Software         100 ----Hardware        150 ----Other              200 ----Other total      250 The other total is a calculated cell where I make a sum of Software and Hardware, This works fine in the cube But the total of turn ...Show All

• Lucky_Luck Seeking help with "inserted" table

  I am writing my first trigger ever and was trying to use a cursor to read through the "inserted" table, but got errors. Is it possible to do this successfully I have found very little information and examples for using these special tables. Sure, we can help you :-) It is possible to use a cursor, but like in the most cases it is not preferable until it can NOT be done by a setbased operat ...Show All

• Gooberfish Difference between 2000 and 2005

  Hi, Have there articles about the difference between Analysis Service  2000 and Analysis Service 2005 Oh my gosh. There is lots and lots. One recommendation that I make to customers is to look at the migration process for a good background on this topic. It won't help you with new AS2K5 features, but it does help you transition from AS2K to AS2K5. A good resource is here: http://www.microsoft.com/technet/ ...Show All

• Sianspheric Unique Integer IDs

  Hello, I wanted to hear from you - if you've used any unique integer generation technique in the context of a disconnected smart client/local data store and have been successful with it. Any ideas/suggestions will be great. Thanks, Avinash We are using unique integer ID generation for our document ISNs. It works perfectly. You just need a good distribution if you have any concurrent processes g ...Show All

• Adrijan extended connection managers for data flow destinations?

  It looks like you can only extended connection managers for data flow sources. Is there anyway to develop a custom connection manager for the SQL destination in the data flow destinations I can’t use hardcoded connection strings. I can’t use configurations because they are not encrypted. I already have managed code that will give the corrected connection string. I already have a custom connection manager that I use from th ...Show All

• Wojo CustomReportItem Installation

  Is there any documentation currently outlining how to make use of the CustomReportItem element or class   My thoughts on this are that it might act as a server control for an ASP.NET application.  Is that correct I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of t ...Show All

• Claudio Benghi Problem converting VS2003 code to VS2005

  Hi: I am trying to convert my VS2003 project to VS2005 beta 2. The actual conversion has gone fine, but some code that was working fine under to old IDE is now giving me an exception when run under the VS2005 generated code. The code is: using ( SqlConnection conn = new SqlConnection ("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GestionNET00001;Data Source=localhost" ) {   ... } And the error I'm getti ...Show All

• Sih Huseyin Ulger Import variable fixed length file

  I have a requirement to import a file of rows containing fixed length data. The problem is that each row can be one of 5 different formats (i.e. different columns) -- where the "type" of row is indicated by the first two characters of the row. Each row gets inserted into its own table. Could I use a simple Conditional Split to route the rows Or is the split for routing similiar rows Anyways, problems are never this simple... In a ...Show All

• JLecht Mirroring and orphaned users

  Hi there! There is still a problem with mirrored (mapped) SQL Users. If you mirror a database where an application connects with an sql user, the mapping (login / user) will be lost on the mirror server. After a failover occurs, it it not possible to log onto the new principal database because the database use will be an orphaned user and has to be remapped to the login (using sp_change_users_login 'update_one', 'user', 'user' ). Is th ...Show All

• budc insert statement

  Hi I am having a few problems writing an insert statement. I have a customer table with lookup values inserted in some of the columns which reference another table customer table name address1 status test high street 0 lookup table code description 0 deleted 1 customer ----------------------------- I need to insert data from the customer table into another but not us the lookup ta ...Show All

• Rivendale Make (Select All) as default value in parameter

  Dear Anyone,   Does anyone know how to Make (Select All) as default value in parameter selection on a multi-select parameter thanks, Joseph We have the hotfix for the (Select All) option applied (after applying SP1). However, when the users change another parameter filter which cascades to change to the multivalued parameter filter, the (Select All) option is not reapplied. In other words, if new entries show up in the multivalue ...Show All

• Liz - MSFT 2005 Expression Edition Install Query

  I have SQL Server 2000 Developer Edition on my laptop which I want to remain for work development purposes (my work uses SQL Server 2000). However, I'm developing a .NET application which requires a database back-end. Can I install SQL Server 2005 Express Edition alongside SQL Server 2000 Or does 2005 overwrite 2000 If no to the first question then how do I develop the system/database in SQL Server 2000 but delpoy it to the user using 2005 ...Show All

• Alexander Gros Which version is best for me ?

  Hi I want to install SQL Server 2005 on a dedicated server. I will be placing around 20-25 databases on this which will be access by same number of web-sites with under 1000 pages visits each per web-site. Can you please suggest which will be the best version of SQL Server for my needs. Thanks for you help. G, Thanks for the help. Is it easy to upgrade from Express to Workgroup or Standard Will I retail all ...Show All

• bubu Mirror Operating Mode change problem

  I am unable to change the mirror operating mode on a test database mirror I have set up. I installed (from MSDN) the RTM SQL 2005 Std Edition and applied SP1, then set up a mirror, which works fine but only on High Safety mode. I want to use High Performance mode, but the operation mode radio buttons are greyed out for me in the mirror properties page. Also, I tried running: alter database TestDB set safety off and recieve the error: Msg 1473, L ...Show All

• szelee ADOMD.NET 8.0 dependencies for connecting to both AS 2000 and AS 2005

  I've got a C# application developed with Visual Studio .Net 2003 which uses Adomd.net (8.0) to access cubes on SQL Server 2000 Analysis Services as well as SQL Server 2005 Analysis Services. In the MSDN reference page I noticed that I can set the connection parameter "ConnectTo=Default", and now, after installing the SQL Server 2005 Client Connectivity components, I can make connections to both AS2K and AS2K5 from my development machin ...Show All