Answer Questions

• CI2 SQLExpress Intermittent Login Errors

  This is very strange... After installing the Advanced Services package, I started getting errors connecting to a database (.MDF) that I've been using for weeks/months. The error was something like "login failed for machine\user". After twiddling with the connection string and starting and stopping the SQLEXPRESS service it started working again. Did some more work, everything was fine, shutdown and went to bed. This morning ...Show All

• Alan Pa Calculating % in Text Box

  Hi I'm On the "Layout Tab" and I'm trying to calculate a percentage in a text box. This works: =((Fields!THIS_QTD_LBS.Value - Fields!PREV_QTD_LBS.Value) This Does Not work: =((Fields!THIS_QTD_LBS.Value - Fields!PREV_QTD_LBS.Value) / Fields!PREV_QTD_LBS.Value) * 100 All I get back when I "Preview" the report is "Error" Why It seems like I should also be able to do the following, but cannot: ...Show All

• sersul Query:Source from multiple tables to a Fact table

  Greetings, Iam new to SQLl2005. Iam using DTS to transfer data from my source to the warehouse. I have a couple of tables in my source whein I have to join these to tables fields and insert the same in teh warehouse fact table. I have used a Join query in my Oledb source component, What other component needs to be used to insert the data into the fact table. I also need to extract same data with aggregation and insert the same into an another F ...Show All

• Martin Vobr Multilingual report ?

  Hi ! Is it possible to create multilingual report. What i mean is when i create an ASP.NET page i can add as many resource file as i have different language on my website. This will change all the texte on my pages to be in the language that the user have select. So i have just one page for 4 diffrentes languages. So i would like to know if it's possible to do something like that. I mean i don't want to do 4 reports if i have 4 differents user ...Show All

• Scott Anderson Sync sql server 2005 mobile edition with ms sql server 2005 express with any avaible connection

  Hello, I am new in developing applications for smart devices. I want to develop a litte application that allows users to add and edit data on their pda. This data is saved on a copy of a .sdf file on their own pda. If a connection (wlan, internet, activesync, and so one) is avaible that files should be synchronize to a sql server 2005 that is running on a server. I heard something like RDA or replication, but I don't really know what to do with ...Show All

• Worrior AS2005 Performance issues

  Hi, We are currently looking into AS2005 performances for one of our client. For some reason the 'cubes' are not giving us the performance we were expecting. Her is some info about our environment. Server: 2 * Dual 2.8 GHz with 4 GB of memory The fact table has around 30 millions of records for three years worth of sales history, and we have created 1 partition per year. We are using MOLAP with aggregation level at around 40%. The bi ...Show All

• Varun.Prakash FYI: I posted about several bugs in April CTP on the Microsoft beta newsgroups

  FYI: I posted about several bugs in the April CTP on the Microsoft beta newsgroups, here:   http://communities.microsoft.com/newsgroups/default.asp ICP=sqlserver2005&sLCID=us I mention it here in case anyone from Microsoft, or anyone else interested, reads this area. (With the February CTP, my bug postings got me a lot of responses on the Microsoft beta newsgroups, but my ones for the April CTP aren't getting any responses, so mayb ...Show All

• Paul Clancy Trying to get the remainder of a decimal by using Formula on a field

  Hello Everyone, Here is my situation. I have a field in a table (named QuestionPosition)(type Decimal) that contains values like this: 1  2   3  4  5.1  5.2  5.3 ... I want to have another field in the same table that stores just the remainder (in the above case a 0 for integer values and the 1 of the 5.1, 2 of the 5.2 etc. I created the field in the table (named QuestionSubPosition) and tried t ...Show All

• jbrunken raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt Now, I have. It worked fine for me. Have you had problems with it I can delete my raw file destination out of the data flow and put a break point on the data flow task and look at my variable. it loo ...Show All

• Juzzi Unable to connect to Analysis Services as a client

  Hi, I got SQL SERVER 2005 SP1 installed on a server and is running fine. I've installed BI studio on a client computer and I can access the database engine. On the client computer, while deloying my cube I get the following error : the project could not be deployed on the server "server_name\instance_name" due to connectivity problems. Verify that the server is running I've checked the project properties and in the deployment section ...Show All

• V J V Fuzzy Group Updates?

  Hi there, Quick Background:   I have an SSIS package that reads data from a flat file then runs it through a Fuzzy Grouping component.  The result of this Fuzzy Group is put into a SQL server 2005 table. Question:   Over time, the flat file will be adding new records (some that should be added to existing groups) and so I'll need to update my Fuzzy Group table to include these new records.  Is there anyway to ...Show All

• Nicoleta columns in indexes

  How are these columns stored If I am learning correctly, the added non-key columns in the index are not part of the index limit If I have a large amount of data that I cannot fit onto an index page, what's being done. Just a pointer to the data that's isolated on it's own page I guess this would be less overheard than performing an index scan with a pointer to the non-key column (I don't know, I'm asking) and no pointer would be better insert pe ...Show All

• Loup Installing databases to different hard drives.

  Can't find anything on how to install to drives other than sys. I'm brand new to Servers and Databases in general and trying to learn. How do I get databases to install on drive partitions other than my main system drive Hi, don’t know if you mean database or instance in your case. Databases can be installed (or created) on medias using the CREATE DATABASE statement using the file destination (more details in ...Show All

• Bobby K MSXML6 breaks viewer used with Microsoft Electronic Learning Library

  Installation of SQL 2005 Express resulted in the failure of the viewer used with the Microsoft Electronic Learning Library products. The viewer runs under IE and is driven by an XML file. This has been verified on several systems. I uninstalled only MSXML6 and the viewer worked normally. I have no idea if the problem is with the viewer script, the XML file driving it, or MSXML6 but obviously this might be a breaking change to the product. ...Show All

• Kanus How to avoid Caching of Reports?

  Hi All, We have a Report wherein we specify the criteria and then generate the report. The issue is when we give a new criteria the second time and generate the report, we get the old result set that was for the previous criteria. How can we avoid this Thanks in advance. Sundar Thanks niallhannon, rs:ClearSession=true thingy worked!! Thanks to James too for his post. ...Show All