Answer Questions

• DMan1 Confusion over SQL 2005 Standard CPU Support

  I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs). Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs) Thanks, Chris. From emperical evidence, it looks like Standard is restricting on logical processors. We have a production config wit ...Show All

• aspfun How to Hide childless members

  Hello, I have a dimension with members that dont have childs, how can i hide those members. Thank you Hello! What setting have you used for the "hide member if property" on the levels resellers and postal code in the user hierarchy Regards Thomas Ivarsson Hi Thomas, its seems to be a bug in SSAS 2005 (in CTP of SP2 too) related to the built in property CHILDREN_CARDINALITY. CHILDREN_CARDINALITY in the AS2000 is always 0, if true children count is 0. And always != 0, if a dimension member has one or more children. with member Measures.[PureChildrenCount] as '[Employees].currentmember.Children.Count' select {Measures.[PureChildrenCount]} on 0, {[Employees].[All Em ...Show All

• Cindy Meister goto Statement in DTS ?

  Hello, Can anyone plz tell me how to use GoTo statement in DTS packages Thanks in advance ! I dont think goto stmt works in DTS ! ...Show All

• BarataMota Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

  First I will thanks for any friends open this one. My questions is: 1.What's the diffrent between Processing a dimension by "Dimension Processing Destination" or just by "Analysis Services processing Task" I found that I could do the same work by both, and the MSDN tell nothing about the diffrence. 2.Why the Process Option in the "Dimension Processing Destination" is diffrent to the Process Option in the "Analysis Services processing Task" to deal with a dimension In the "Analysis Services processing Task",the Option is the same with the MSDN, without the "incremental" option. But in the "Dimension Processing Destination",there is the "incremental&qu ...Show All

• Ross B. The Process Could Not deliver the Snapshot to the Subscriber, using WebSynchronisation 2 server setup

  I am Having trouble trying to set up SQL Server Replication Utilising Web Synchronisation Where the IIS(Web Server) is on a separate machine to the SQL Server(Publisher). I am using MSDE as the SQL Server Box, however even when I used SQLServer2000, or SQLServer2005 I have had no joy with the 2 separate Servers setup. If I have the one server then I have no problems (i.e. One Server Setup) Server A: Windows 2000, with MSDE installed enabled for Merge replication, and has a Publication set up. IIS Web Page Setup for Synchronisation My SQL Server 2005 Mobile device syncs via the web page on ServerA Fine, no problems at all. The Trouble is when I am trying to utilise SQL Server Replication as follows. (i.e. 2 Server Setup) ...Show All

• Rafael Mores Split pipeline

  This is probably obvious, but how do I split a pipeline. I.e. I've got a data source with 200 columns - I need to split this into 20 pipelines each containing 10 of the original columns. Hi Rafael, You're correct, conditional split doesn't work. I've got 200 columns from an excel source F1,F2,F3,F4... What I need is to split into multiple streams F1,F2 F3,F4 F5,F6 And then recombine into a single stream F1,F2 F2,F4 F5,F6 I tried multi-cast which works, but the package is unmanagable - the Visual Studio UI slows to a crawl, and if you change the lineage down stream everything breaks and the UI locks up... Dave I've got 2GB of ...Show All

• forrestcupp Security differences between Reporting Services and Business Intelligence Development Studio

  I have a Sales cube in Analysis Services with Security Roles set on Company Code. When I add a Parameter in Report Builder in Reporting Services using Company Code, it will only show that Company Codes specified to that current user, which is correct. If I build the same report using Business Intelligence Development Studio and I deploy the the report, then when I open the report in Reporting Services, it will show no Company Codes, and I am using the same user account. If I specify that the Parameters shows empty and null values, it will show the Company Codes but when selecting the Company Code, it sees it as a dbnull value. Do anyone know what I am doing wrong or what setting I am missing. Thank you in advance. Joos N ...Show All

• sanaku ms sql 2005 delete record problem

  I'm facing problem when delete a record in the ms sql 2005 . The error message i got is stated below: No rows were deleted A problem occured attempting to delete row 1304. Error: .Net Sql Clint Data Provider Error Message: Possible index corruption detected. Run DBCC CHECKDB. Correct the errors and atempt to delete the row again or press ESC to cancel the changes. just certain record i can not delete and face this problem. i detach the database and attached in the ms sql 2000, and select the same record to delete. there is no problem at all. i wander is it ms sql 2005 bugs can anyone tell me how to fix it .. how to to use the DBCC CHECKDB thanks alot.... P/s : if i posted at the wrong section jus ...Show All

• AstAn Analysis Services error

  I was able to build SQL 2005 cubes from my project. However, for some reasons, it doesn't work any more, and I have the error below. Anyone can shed some light would be greatly appreciated. Error 1 File system error: The logical file cannot be found inside the physical file. Physical file: \\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.6.dim\14.ERP Effective Month.Tbl Policy Coverage Data.dstore. Logical file: . Errors in the metadata manager. An error occurred when loading the Coverage dimension, from the file, '\\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Beacon DW.0.db\Tbl Policy Coverage Data.16.dim.xml'. Errors in the metadata manager. An error occurred when loadin ...Show All

• Keehan Failover Clustering and Standard Edition

  I am reading that SQL Server 2005 Standard Edition supports failover clustering but up to two nodes only: " Support for failover clustering in Standard Edition is new in SQL Server 2005, and only two-node failover cluster instances are allowed using that version of SQL Server, even though the cluster itself might have more nodes. " I take this to mean that if I have, say, an 8-node cluster I can put several instances of standard edition in that cluster (up to 16 per node), as long as a single instance is configured to run on only two nodes. Is that correct Thanks in advance, Candice As long as each instance/node is properly licensed, you are correct. Beautiful... thanks for ...Show All

• Andrew Zhou Change the Authentication Mode of the SQL server

  I installed SQL Server 2005 using Windows Authentication Mode (Windows Authentication) " How can I change the Authentication Mode of the SQL server from " Windows Authentication Mode (Windows Authentication) " to " Mixed Mode (Windows Authentication and SQL Server Authentication) " Hi, refer my blog where i mentioned method of changing Authentication with registry. http://hemantgirisgoswami.blogspot.com/2006_11_01_hemantgirisgoswami_archive.html Hemantgiri S. Goswmai Sorry, found the ans after posting here. FYR: Expand a server group. Right-click a server, and then click Properties . On the Security tab, under Authentication , select the Aut ...Show All

• Fox Me Up share variable with child

  How a parent package can share its variables with child when calling it using Execute Package Task Andy Leonard wrote: Hi Fahad, Phil is correct. A couple things to note: the variable shared between the parent and child packages must have the same name and data type. Hope this helps, Andy They shouldn't need the same name, is my understanding, as you choose the "value" parameter of the variable you'd like to map to. Hi Fahad, Phil is correct. A couple things to note: the variable shared between the parent and child packages must have the same name and data type. Hope this helps, Andy Parent Package Variables.... Right click on the background of the contro ...Show All

• JohanK SSIS refresh fails

  When I use the OLB data source (SQL SERVER 2005), select * from tableA, then use several steps and then Union ALL and Fuzzy Match, the process works fine. When I change the data source SQL to include two tables with a cross join, the new fields in Table B do not appear in the Union ALL or Fuzzy Match steps but do appear in all steps prior. The advanced editor refresh does not fix the problem. Deleting and recreating the Union ALL shows the Table A and Table B fields. Fuzzy Match is still incorrect. Deleting and recreating Fuzzy Match fixes it. I'll try but I only work on it during the weekends. clecknerj wrote: Thanks for the help. I'll read in the Wrox book. ...Show All

• EltonSky Hide some columns in Matrix but not in subtotal

  Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% € 217.763.099,50 € 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 € € 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% € 847.871.349,50 € 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other w ...Show All

• Joao Richiard Frequency Query

  on a SQL 7.0 database is it possible to do a query to analyze frequency of the entries in the database in other words I want to know which entries have the most instances. thanks again. Gary Yes but you should do it like this: select TagName, count(*) from alarmlog where eventstamp > '02/01/2007 00:00:00' and eventstamp < '02/02/2007 00:00:00' group by TagName FYI: This is a good site with basic SQL syntax: http://www.w3schools.com/sql/default.asp Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog You can add as much columns as you want but the column must be included in the group by clause OR included in an aggregate function like (SUM, AVG, MIN, MA ...Show All