SQL Server

Page 4274




  • Topics
    Replies
    Last post
  • Can Fact Table function without Measures?
    by cherriesh
    0 Replies
    Last post by cherriesh
      • Hi, I'm new to Analysis Services. I just wanna ask if it can function like a listbox with different attributes relating to a dimension and I can filter it the same as AS has for filters. Let say: Customer No Account No Date Valid Fr Date Valid To Active 001 111 04/05/2007 05/05/2008 Yes 002 222 06/05/
  • SQL Server Express SP2 as a prerequisite
    by rastevens
    14 Replies
    Last post by CalinMac
      • The just released SP1 version of SQL Server Express has a file name of sqlexpr.exe. The previous setup file was named sqlexpr32.exe. Why would Microsoft change the file name Anyway, the file name change obviously breaks the file name that is coded in the bootstrapper package.xml file. Also, the link address will need to change (I suppose Microsoft couldn't just put a new version at the same li
  • Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)
    by I.W Coetzer
    8 Replies
    Last post by I.W Coetzer
      • Hi Last week I was receiving an error when trying to connect to two of our seven sql servers from my laptop via my domain admin account. The only fix was to have my laptop rebuilt and everything re-installed. Today however another administrator is starting to have the same problem but to only one of the seven servers! When that administrator uses my laptop with her domain admin ac
  • No records read from XML Source xml file.
    by Stuart580238
    14 Replies
    Last post by Stuart
      • I have a simple data flow where I am trying to import data from an xml file into a SQL Server table. I have an xsd that seems to work because the XML Source can pick up all the elements in the xml file. The problem is that the process executes successfully without any rows being imported. The xml file has lots of data. But no messages or warnings are given to suggest why no rows are being written
  • Can I retrieve a result set from a sp into a variable within a Execute SQL Task?
    by agentf1
    14 Replies
    Last post by Phil Brammer
      • Can I retrieve a result set from a sp into a variable within a Execute SQL Task
  • UPDATE-Cannot shut down VS after using report designer
    by BobP - BIM
    14 Replies
    Last post by Lukasz Pawlowski -- MS
      • Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only
  • Localization of reports
    by DarshanAltekar
    1 Replies
    Last post by Rakam
      • How can i add resources to my report (*.rdl) at runtime depending upon the curren culture ie text ,date formats ,currency setting getting changed according to current culture.Is there any way i can define resource file for report
  • AMO Class library: MdxScript Commands
    by Markus Fischer
    4 Replies
    Last post by Christopher Webb
      • Hi, I have a question regarding the AMO Class MDX script. As desribed here http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.mdxscriptcollection_members.aspx there seems to be a collection with several MDX scripts and a marker for the active script collection... Does anyone know if BIDS always uses collectionitem(o) from the enumeration or is it possible to handl
  • Documentation
    by Nfrf
    2 Replies
    Last post by Nfrf
      • Hello, I have a BI solution in SQL server 2005, is there a documentation tool to help me do the documentation for my project I use SSIS, SSAS and SSRS. I need documentation for the first two. Thank you
  • filtering with set?
    by lancastro1416
    4 Replies
    Last post by lancastro1416
      • i have two dimensions named dimLocation and dimTargetSet. What is needed is to count the members of dimLocation that is also a member of dimTargetSet. I am thinking of using a filter but have no idea what to do. Count(FILTER(Descendants([dimLocation].currentmember,9,Leaves), )) Any ideas ... thank you so much....
  • microsoft visual studio cannot shut down because a modal dialog is active
    by chicagoclone
    14 Replies
    Last post by Jerry Hung
      • if i get this message one more time I am going to put my fist through my monitor
  • Switch Of Query Design Mode
    by J M B
    2 Replies
    Last post by J M B
      • Hi all, I have a couple of reports with predefined queries. When I try to edit a data set query it goes directly to query design mode losing the query I already had. As you can see this is a real problem because I can't edit queries. How can I switch off design mode any ideas are pretty much appreciated. Cheers
  • being able to stop parallelism in a C++ Program calling SQL Server
    by peternolan9
    3 Replies
    Last post by peternolan9
      • Hi All, I have written ETL software that runs on SQL Server. We are running it for the first time on a 4cpu (2 x dual core) machine on sql server 2005. One of the things this software does is perform a 'select * from tablename' to validate that the tables passed to it as parameters exist. This has worked fine on previous releases and on single cpu machines because what the optimiser deci
  • Export ReportItems in header different btwn Excel and PDF
    by mattcushing
    14 Replies
    Last post by Lisa Nicholls
      • I have a sum on a reportitems cell in my header: =Sum(ReportItems!textbox1.Value) When I run the report, it looks excellent. My issue is when I export it. When I export to Excel, it looks just like it did. When I export to PDF, it gives me a total per page, not for the report. Does ReportItem behave differently when rendered between excel and PDF Or is it because I am putting a SUM on a ReportIte
  • Package configurations
    by KoryS
    7 Replies
    Last post by KoryS
      • Before I started using package configurations, I made several (wrong) assumptions. My primary use for configurations are to move packages between environments (dev, test, prod), so my config files only contain connection information. My first assumption was I could create 3 different configuration files (XML) with the connection string properties for each environment. Because I use shared
  • SQL Server Express error: 5 Access Denied
    by Brandon0223
    2 Replies
    Last post by stanley john
      • After installing SQL Server express to my WinXP machine, when I attempt to restore a database from a 2000 backup, I get the following error: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\TEST.MDF'. (Microsoft.SqlServer.Expres
  • My Cube is empty after processing - where did the data go?
    by SADave
    6 Replies
    Last post by SADave
      • Hello! I inherited a cube from another developer. After working though it for awhile and fixing broken views etc, I am able to get the cube to deploy and process. However, the cube appears to be empty. I can retrieve no data from it at all. In Dev Studio, I can drill through the data source to see that the tables and views are actually populated, but nothing appears inside the cube.
  • sql 2005 Database contains deferrd transactions
    by SQLBOY36
    5 Replies
    Last post by SQLBOY36
      • Help, I had a tran log grow to it's restricted size, however the person that created this made the max size almost equal to the set max size. Needless to say I have not space to work with. SQL got bounced and my db went into recovery mode. After recovery mode was complete I tried to put my database in emergency mode but it exec's but never sets the mode. Next I tried to dbcc checkdb and I get msg
  • Unexpected BIGINT conversion behavior
    by MichaelT
    12 Replies
    Last post by Matt Masson - MSFT
      • I've recently been struggling with moving a bigint data result from a query into an SSIS variable through the Execute SQL Task. Now, I could just be doing this incorrectly, but I couldn't get it to work at all if I made the variable int64 in SSIS. So here's what I found: 1. bigint from the query into int64 SSIS variable doesn't work at all. It fails. 2. bigint from the query into string
  • A Dimension Attribute with Double DataType converts a zero member to "(blank)"
    by RobbieJ
    2 Replies
    Last post by RobbieJ
      • In one of our SSAS 2005 sp2 cubes, we have a Dimension sourced from an Oracle table, with an Attribute that has a DataType of Double. When we process the Dimension and browse the Attribute, we see the following members: All -.01 -.002 .00000000001 .0000000001 Unknown Notice how its blank where the '0' (zero) member should be. The underlying Oracle table does
  • Error trying to design script (Script Component)
    by Alonso Villanueva
    14 Replies
    Last post by ktheman
      • Hi everybody: Maybe somebody around here can help me out with this one. I applied SQL Server 2005 SP 2 to my local environment (win 2003 server) about two weeks ago week and last week I noticed an error when I tried to edit the script components of some previously created packages. I am not 100% sure that SP 2 is the cause but that's the only thing that has changed recently. Well, this is my error
  • Report render to PDF hangs
    by S Anderson
    8 Replies
    Last post by plengski
      • I've got a complex report with many subreports that is running on a reporting services 2005 machine with sp2 installed. The report was working well, producing a 2800 page report in under 10 minutes. I made a change to an expression in a table's column header and one change to the detail and the report stopped working. It would just hang for hours with no messages in the logs. I tried to simplif
  • The encrypted value for the "Dsn" configuration setting cannot be decrypted.
    by Vlad_OM
    1 Replies
    Last post by beysselinck
      • I overwrote rsreportserver.config with one from a different installation and that killed my RS because of the encryption key inside that file. Is there any way to generate that file for current install or do I have to reinstall the whole thing now Thanks
  • Removing '<Select a Value>' in parameter drop down
    by DominicRG
    0 Replies
    Last post by DominicRG
      • Hello I have a parameter whose default value is null, so when the report first appears, 'select all' is displayed in the dropdown. The problem is that '<Select a Value>' is still one of the options in the drop down list. I'd really like to remove it. Does anybody know how Many thanks Dominic
  • Help: How to improve the speed of Sync.
    by YoungC
    5 Replies
    Last post by ErikEJ
      • I have a table which has around 132000 rows with 24 columns. I use rda.pull download the data to PDA. For query these data, I must create a index on 5 character columns. The data download time is good enough, around 4 mins. But it takes 12mins to create the index. Please help to give me any idea on how to improve the whole synchroniztion speed. Thanks!