Answer Questions

• Shadi_05 Forcing Calculated Measure to be calculated at processing

  When is a calculated measure calculated My understanding is that it depends on the aggregation level and can be pre-calculated if the aggregation level is high enough in the aggregation design. I have a calculated measure that is core to all my processing and is the main reason for building a particular cube, Is there anyway I can force a calculated measure to always be calculated as part of the processing Only real measures and measures expressions are precomputed during processing. Calculated measures cannot be forced to be computed during processing. So how can I get a pre-calculated measure without having to do all the work in SQL as part of the DSV Can I create a real measure which ...Show All

• Avi Edri Copy Database Wizard Problem

  I am trying to copy a database from SQL server 2000 to SQL server 2005. In using the Copy Database Wizard I am getting an error. I have selected the SQL Management Object method as the transfer method. The error is occurring on the create package step when running. The error code is: "While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Client unable to establish connection)." I'm receiving the same message when trying to copy. I first installed SQL Express then updated to Developer edition. Error: While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Client unable to establish connection). ...Show All

• ClayD Strict Transaction Nesting Bug with CLR

  Dear all, I am constantly running into this error when calling CLR functions from triggers (even when the triggers are CLR functions themselves): The context transaction which was active before entering user defined routine, trigger or aggregate "[name of CLR sp]" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. However, there is no cyclic nesting going on here. In fact, the error only appears when the CLR function is writing to the database. Only executing SELECT statements inside the statements doesn't freak out the SQL server (2005 SP1 in my case). I am not ending any transaction at all. This error shows up in many places: as exceptions from ASP.NET web pages, ...Show All

• Sabrecat connect to AS2000 cube error

  Here is my setup: I have Reporting Service and SQL Server 2000 in one box (Box A), and IIS and Analysis Service in another box (Box B), which has couple of cubes based on the database in Box A, using SQL Authentication and Allow save password. Create AS2000 data source at Reporting Project, then create a report, I can preview the report fine in VS.2003. But I got the following error after deploying the report to the reportserver and browse the report: Cannot create a connection to data source 'Cube'. (rsErrorOpeningConnection) Get Online Help Database 'Cube' does not exist. Do I miss anything Thanks Reporting services and Analysis Services only support Windows authentication. Another problem with your setup is that even if you ...Show All

• michaelmwelch Time Dimension

  Can anyone explain how the time dimension works in cube I have differenct tables to store different dates. Which do I point the time dimension to Thanks. Regard Alu You will need to have time dimension records for each fact records date. If you do not have complete time/date records in each time table, you can use TSQL UNION to build a view or a new table with all records. In SSAS 2005 you will only need one time dimension table, even if you have several different dates in you fact table like ship date and order date. In the previous version you would have to build two different views or tables for this. In SSAS 2005 you join the same time dimension table to the time foreign keys in the fact table, in the data sourc ...Show All

• David222 How can I reset a database surrogate PK using SSIS?

  I have a database surrogate key that increments so rapidly (+5000 every 30 mins). I need my SSIS package to reset this database surrogate key to avoid reaching an upper limit value for that field. How can I do that using SSIS package thanks, Aref A quick Google revelas that you can use DBCC CHECKIDENT to do this http://www.mssqlcity.com/FAQ/Devel/reset_identity_column.htm You can issue the command using the Execute SQL Task. -Jamie ...Show All

• winstonSmith Error on build solution, if SSIS project is part of build

  Hello, we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this.. C:\Programme\Microsoft Visual Studio 8\Common7\IDE\devenv.exe (c:\Development\X3\\X3.sln /build Release)' in 'c:\Development\Projects\DailyBuild Through build process we get a error: External Program Failed: C:\Programme\Microsoft Visual Studio 8\Common7\IDE\devenv.exe (return code was 1): We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user ...Show All

• NozFx Avegage from 4 columns

  I have 4 columns and i need average from this columns. I can sum values from this columns and divide by 4, but this is inproper in case of nulls. Is there any easy way to do that Right now I'am using: select (isnull(column1,0)+isnull(column1,0)+isnull(column1,0)+isnull(column1,0))/4 FROM TABLEX Can you post a small sample with some numbers demonstrating your problem, along with the desired output and also an explanation with rules of exactly how you want your averages calculated /Kenneth I can't divide by 4. I must count not null columns. I must divide by 4 or 3 or 2 or 1 (depends on values). This is probably the best way to do it. It is straightforward ...Show All

• IrishGandalf SQL Server Edition ??

  Hi, I was wondering, what kind of SQL Server 2005 edition is allowed to be used on the development server. We have the developer's edition, would we have to buy an Enterprise edition for the development server Thanks, Tanvi. I certainly don't claim to be a licensing expert, but I think this is exactly what it is intended for. :) "Each license of SQL Server 2005 Developer Edition entitles one developer to use the software on as many systems as necessary and additional developers can use the software by purchasing additional licenses." Thanks, Sam Here is a good explanation of the different SQL 2005 editions: http://www.microsoft.com/sql/editions/default.mspx F ...Show All

• Jazzbo Property DefaultSchema is not available for Database [DatabaseName]

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• AP Erebus date parameter issue

  hi all We are a multi site / multi language company so do not want to hardcode the date format - these reports will be on intranet Using MS Sql - Reporting Services 2005 Using no formatting on fields = yyyy-mm-dd - is how it is displayed. I added a @startdate and an @enddate parameter I read up and saw this information: Report properties set 'Language' setting to '=User!Language' to detect user culture automatically My regional settings are set to English (New Zealand) but whatever I do I receive no data - (data is definately there eg when run without parameters) so it is obviously the dates incorrect. Can someone give me some advice on what else to check. SQL : SELEC ...Show All

• p_dinesh simple question creating duplicates

  Hi, I'm trying to create duplicates in a copy of a table in the same database by inserting rows from the original table. Seems easy but I can't get any sql to work. help I tried the code above and it failed, saying a specific column did not allow nulls. Now I have a copy of Northwind with all of the data. It exists in Northwind also. I don't want to do anything to the original so I tried this code. It seems like such a simple thing to do. I want 16 rows in Categories in the NorthwindCopy database. Right now I have 8 rows and I want duplicates of those 8 rows. I tried this code as I don't want to rollback: use northwindCopy insert categories(CategoryName, Description, Picture) SELECT CategoryName, ...Show All

• Mohsen Kokabi Property DefaultSchema is not available for Database [DatabaseName]

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• Jon Watte How to install ascmd.exe utility?

  I have istalled SQL Server 2005 SP1 Standard Edition and AS 2005 without Samples. How to install ascmd.exe utility on the server and client Thanks, GB bump Does anybody has an answer about this one Anyone Hi everybody, I have the same problem. 6 months ago I download et compiled the solution ascmd to generate ascmd.exe by SQL Samples. Now it's impossible to find the solution. Thanks for your help Massimo Hi I was not able to download Ascmd.exe util. does anybody know where can i get it I'm trying to run XMLA from command line. is there another why to do it Thanks for your help Nir You will fi ...Show All

• anubisascends Restoration of publication database backup

  When I tried to restore backup of publication database, time taken for restoration is too long [ 4 hours]. The actual database restore takes only 20 minutes but the stored procedures used for cleanup replication takes the remaining time. Is the issue related to my environment or the cleanup replication stored procedure i have a restore going on for about 3-4 hours. my db contains not more than 100 records thats too much i should say maybe 50. and number of tables is 10-15, about 10 stored procedures. sql server enterprise , lucky i tested this backup/restore with this small db. Any latest news about taht thanks. Microsoft identified this as bug and the development team is in the pro ...Show All