Answer Questions

• pederjohn SQL Engine on XP 32 bit

  We are trying to install Ponemah (DSI) Application and it stops every time with no errors but in the same place. It installed perfectly on other computers. This one is XP also - can't find differences except that when we look we can see that the application does not create the sql engine. Do we need to reinstall office or what is it that will repair ODBC The tech support for the product has not been able to find solution. Are you trying to install SQL Express Some other SQL edition Please post the logs from your failed install and we'll help troubleshoot. Thanks, Sam Lester (MSFT) ...Show All

• Terry Fox mdx questions

  I'm going to start reading through the performance document, but in the mean time any suggestions on how to speed up the following with member Measures.bucket1 AS sum ( filter (([REL TURN HRS].[REL TURN HRS].[REL TURN HRS]. members * [Measures].[FACT CUT RELEASE Count] ) ,[REL TURN HRS].[REL TURN HRS]. membervalue < 6),[Measures].[FACT CUT RELEASE Count]), NON_EMPTY_BEHAVIOR = { [FACT CUT RELEASE Count] } SELECT NON EMPTY { [Measures].bucket1} ON COLUMNS , NON EMPTY { ([CUSTOMER JOB].[Cust-Title-Issue-Job].[JOB_NUMBER]. ALLMEMBERS ) } ON ROWS FROM ( SELECT ( { [CUSTOMER JOB].[CUSTOMER NAME].&[T016]&[TIME4 MEDIA, INC. (T016)] } ) ON COLUMNS FROM [DW INSIGHT]) WHERE ( [CUSTOME ...Show All

• Andrew Buyan Parameterized MDX Query Performance Issue in SSRS

  Hi, I'm having issues with a reasonably complex MDX query used in a Reporting Services report. I have executed the query and traced activity on the SSAS box and have discovered that there is a major difference in performance between the parameterized query and the exact same one but with 'hard coded' values. The difference we are talking about is from a couple of seconds (hard coded) to minutes when parameterized!! The key difference is that the parameterized query is causing litterally hundreds of thousands of Query Dimension events (EventSubClass : 1 - Cache Data) to occur against one of the dimensions (the Date dimension to be exact). This dimension is not even large with only a few hundred leaf level members and about five levels ...Show All

• dsani Data Flow: Converting data in multiple columns

  Hi, I'm just wondering what's the best approach in Data Flow to convert the following input file format: Date, Code1, Value1, Code2, Value2 1-Jan-2006, abc1, 20.00, xyz3, 35.00 2-Jan-2006, abc1, 30.00, xyz5, 6.30 into the following output format (to be loaded into a SQL DB): Date, Code, Value 1-Jan-2006, abc1, 20.00 1-Jan-2006, xyz3, 35.00 2-Jan-2006, abc1, 30.00 2-Jan-2006, xyz5, 6.30 I'm quite new to SSIS, so, I would appreciate detailed steps if possible. Thanks. Ok, I have found a method to get what I wanted, but I'm not sure if it's the best approach. Any comments appreciated. I first used a Multicast and feed the input data into 2 Script Components. The first ...Show All

• Leon Mayne BI Portal connected to analysis services 2005

  Anyone has connected the bi portal with analisys services 2005 I have a security problem. Thanks I had to do this a couple of days ago. The only way I could get it to work was if I went into the advanced options on the Data Source and specified the full connection string myself, making sure to specify MSOLAP.3 as the provider. When I just chose the options from the standard connection dialog, I could not get it to work, however I was running the BI Portal for a demonstration from a virtual server so their could have been other complicating factors involved. Note: because BI Portal uses OWC you will need to have the OLEDB provider for AS 2005 installed on all your client machines. Hope this helps. I did wha ...Show All

• subhasam Distributed query from SS 2000 to access catalog views on SS 2005 via linked server

  I am trying to write some admin only procedures which will collect information to one of my development server from other production and development servers.   I have created linked servers to access these other servers on the development server. This development server is SQL Server 2000 EE. Other servers which I want to access are 2000 and 2005 (vaious editions)   E.g I have another development server called PRODTEST which is SQL Server 2005 and on the development server I have created a linked server pointing to PRODTEST called TESTLINKSRV. I want to access new object catalog view (as I do not want to use sysobjects)   When I run the following query   SELECT * FROM [TESTLINKSRV] ...Show All

• Andeezle The attribute key cannot be found - two cubes - different results

  I am working with a cube that was built by someone else.  I reverse engineered it to create a project and I am trying to re-deploy it in a development area.   I keep getting the ‘The attribute key cannot be found: …’ error on a fact table key.   When I use a SQL script to check if there are any missing keys in the dimension table they are all there.   I have tried dropping the dimension from the cube and adding it back and changing the DSV from table to Named Query.   Nothing fixes the problem.   As a test I created another project and included only the fact table and the ‘problem’ dimension and I was able to successfully process the cube ! !   I would rather not ‘ignore the errors’ ...Show All

• SSAS AS2005: write a cube to a local .cub via xmla?

  Hi, i wonder if it is possible to write a cube (in AS2005) to a local .CUB file using xmla instead of the "old" CREATE GLOBAL CUBE statement ... I haven't found anything in the msdn ... perhaps I've been blind background of this question: http://forums.microsoft.com/msdn/ShowPost.aspx postid=463952&siteid=1 Thanks for your answers and for tolerating my bad english best regards, Sven Thanks for your quick reply! We used the Profiler before and found the xmla-statement that is used to create the new cube ... no problem so far; it creates a new database with the cube as we want it to be. But we didn't find the xmla-statement that writes the cube into the .cub file. T ...Show All

• Lino17580 Mysterious login error message

  I get the following error messages in the sql server error log Source Logon Message Error: 18456, Severity: 14, State: 11. and Source Logon Message Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 185.23.11.33] The scenario is: We set up log-shipping (LS) between a clustered sql server system (source server) and a stand-alone sql server box (target server). (SQL Server 2K5 EE + SP1), and LS goes very well, but on the target server, we found the above-mentioned error messages. BTW: the two servers are in the same domain. Did I miss something in configuration Thanks in advance for your help.. Jeff It looks like a delegation problem. Most likely the credentials from a 3rd mac ...Show All

• funkmonkey duplicate rows in 1 csv file

  Hi, I am trying to import data from a csv files to a OLE DB Destination. The csv files contains all transactional changes . For example for a particular record the firstname, lastname, email address records change within the same csv file. I need to save only the last updated record from the csv files. I have tried "slowly changing dimensions" but these dont work when there is duplictes within the same csv file. Also have tried 'Sort' but this only stores the first occurance. Any ideas how i can store the latest changed data within 1 csv file. How does the process distinguish between the latest data and duplicate data Is there a date as part of the row or is it just the last row wins Kirk ...Show All

• mdschwarz Perspectives 64 Bit Standard Edition - Not Supported

  I received the following message: Error 1 Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the '64 Bit Standard Edition' SKU. Does the 64 Bit developer Edition Support this Any suggestion we need to test and stage on our dev box before deploying to 64 bit enterprise prod box. Thanks, The 64 bit developer edition will allow you to create perspectives. Here is a link with the different features for each edition: http://msdn2.microsoft.com/en-us/library/ms143761.aspx ...Show All

• Deeps_123 Is there anything like rowid, rownum like in MySql and Oracle??

  Hi, i am new to SQL Server. I want to write a query where in i want to delete duplicate rows from a table keeping the master copy. If it is MySQL or Oracle we can write that using built in rownum or rowid. How to do that task in SQL Server 2005. Is there anything like rowid, rownum in SQL Server If not suggest me a way to do that ...aazad okk...lect us say u want to make column1 as ur primary key in table1 , so to find out the duplicate(or more) entries of this key , use the following query... select column1 from table1 group by column1 having count(column1)>1 this will enlist all the entries for column1 which r repeating... Thank god .. you are using SQL Server 2005 use the following query ...Show All

• eyeseesharp Error deploying DataSource (rsAccessDeniedToSecureData)

  Hi! we've installed the June CTP of SQL Server 2005 Standard. If I try to deploy a report project with Visual Studio 2005 Beta 2 I get the follwoing error: The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) The same error occurs if I try to create the datasource directly over the web-frontend. If yet tried to enter the Administrator account in the WebServiceAccount property with no success. What is wrong Thanks in advance... Markus Thanks Aranda, it corrected my (rsAccessDeniedToSecureData) problem. Ju ...Show All

• johnny_no1_boy SQL Server 2005 - How to create multiple password policies for SQL authenticated IDs?

  We have a need to have separate password policies for different groups of logins. For example: Those IDs that have greater privileges should be rquired to have more complex passwords that expire more frequently than IDs with lesser privileges. It appears to me that SQL Server pulls the password policy from the default Active Directory domain group. Is there a way to create/utilize multiple policies for SQL Server authenticated IDs Thanks for your assistance. Currently, Windows only supports one domain policy. You may want to ask on a Windows forum to see if there are any planned changes in this area. For your reference, the password policy in SQL Server enforces the Windows password policy, lev ...Show All

• CJW99 Either SQL or VB is automatically applying time offsets on my data

  I have a windows app which is used in australia and uses web services to communicate with the database located in new zealand. I have a problem where dates that are returned from SQL are automatically modified to suit the timezone and i dont know how to turn it off. For example, i insert the value '10/Jan/2006 20:00' into the database from a PC located in australia. When that data is selected back out, a 4 hour time offset is automatically applied to it and the time is returned as '10/Jan/2006 16:00'. My current workaround is to modify my queries to say; "Select convert(varchar, tb_date) tb_date from tablename" Which returns the date as a string rather than a datetime which means the time offset is not applied. This is a really p ...Show All