Answer Questions

• Jabbabroadley Installing of Reportservices failed

  I tried to install reportservices on my SQL Server 2000 SP4. After inpot of the SQL Server datas I got a message windows which says: This version of report services does not support the selected database. Try a diffrent SQL Server Edition. Does anyone have any ideas Thanks for help in advance! martin As I recall, Reporting Services for SQL Server 2000 only works with the Standard, Enterprise, and Developer e ...Show All

• Malini Reddy The AdventureWorks Database Diagram Sucks!

  Shouldn't there be some design discussions on the AdventureWorks database diagram Does everybody agree with the design Are there any major or minor flaws in the design Was the database normalized correctly - if not where and why Do you agree with the choice of surrogate and natural keys Why do you think it was done this way and not that way Are there any data modeling vendors (other than Visio) that have created this schema usi ...Show All

• shan_itc Mutli development on Analysis service

  Is it possible to integrate two cubes develop by difference developers into one analysis service project Example: Cube A developed by Developer A, Cube B developed by Developer B, once completed, I would like to merge into one project, can i do that in AS2005 Thanks Thanks for the advice. This is pretty easy if your dimensionsions are the same. If yo ...Show All

• Shells Union Joins

  Ok, here's the deal. I have created a database for one of my clients and for security reasons I need to use two similar tables to hold the exact same type of information. One table is for general use, the other table is only used by the administrator. But because the information is all the same, I need a way to join the two tables together thru a query so that the dropdown box displays all the combined information from the two tables. The reason ...Show All

• Daniel Wellesley Unable to install sql server 2005

  I got the following message when I try to install the SQL server 2005 June CTP. "SQL Server 2005 CTP Setup has detected incompatible beta components from Visual Studio or SQL Server. You must run the build cleanup wizard from the CD to remove previous SQL Server 2005 components and .NET Framework components, and then run SQL Server 2005 CTP Setup again. For detailed instruction on uninstalling SQL Server builds, see the SQL Server 2005 CTP rea ...Show All

• Dave Harris OLAP cube design

  Hi, This is an OLAP cube design question. I have a cube that was running fairly ok but now has started showing memory errors as the data being processed has increased considerably, so I have started to doubt the design of the cube. I have an SQL database that stores the information of people visiting certain web pages of mine, and analysis server running on it so that I can do analysis of trends of people accessing my pages. For example, I want ...Show All

• Crystalz Value dimension

  Hi, I have a dimension 'Customer' with 15 customers. When I look at the value of a customer it shows : [Customer].[Name].&[1] (this is the value for Kelly Woods). Is it possible to show it as [Customer].[Name].[Kelly Woods] thx Hi, This is my connection string. But it doesn't work! myConnection = new OleDbConnection("Provider=MSOLAP;Initial Catalog=bio;Data Source=Server;User ID=INTRANET\\wdj;Passw ...Show All

• Spadzan SQL Locking up

  Posted - 12/25/2005 :  10:54:44       My ADO based C++ application works fine for sometimes 15+hrs just fine. Im using SQL 2000. All of a sudden I dont know what happens all update operatins and insert operations start failing with 80040e31, timeout expired errors. It seems as though the whole database is locked up. And after 1hr or sometime 2 hrs everything is back to normal without an ...Show All

• Dortz Altering a connection manager dynamically via a variable

  Within an SSIS Package, we are trying to change the connection string of an output file connection manager at runtime (used for package logging). To do this, we have defined variables with package-level scope and set the connection manager connection string to this variable. The first step of the package is to set these variables. The second step begins the rest of the package operations (moving data). The package executes successful ...Show All

• Anon Where can I download the 'adventure works DW' sample database ?

  Hi, all here, Could anyone tell me where can I find the 'adventure works DW' sample database for the SQL Server tutorial projects Thanks a lot in advance for any help. http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en Hi, Santiago, thanks a lot for your help. I have the same problem. I have just installed SQL 2005 and it is up and running but ...Show All

• ranjithr Dependent report parameters help

  I have four parameters for my report: StartDate, EndDate, TankID (the ID of a thank going from V01 to V20 and from S01 to S20) and Site (the location of the tanks, for example: the V-tanks are in Belgium (BE) and the S-tanks are in Spain (SP)) The thing I want to do is: If I set parameter "Site" to "Belgium" then only the tanks in belgium will be shown as values in the dropdown of the "TankID" parameter. If site = ...Show All

• Sten Palmqvist Data-mining model process-error

  I am trying to write some DMX queries to create and populate a mining model as a SSMS analysis services project. I followed the following steps: 1. Create the mining model using a CREATE MINING MODEL ... query. 2. Followed by the - INSERT INTO MINING MODEL ... query, which fetches prediction data from another mining model to populate the mining model. 3. I now want to use this new model for prediction, which requires processing the mini ...Show All

• martinnickel error:an item with the same key has already been added

  hi. i just moved to the april ctp beta 2 version of dts(i know it's already late to do that). i created a new project and moved the packages i did on beta 1 into it. after building it, and when i run the dtsintall.exe, it got this error : an item with the same key has already been added (mscorlib). what i did is excluded all the packages from the project and ran it for one package it worked..gradually i added a package after the other ...Show All

• Ankur gupta - Schema Locking

  My question is about records locking at the schema level. We have several customers in one database. We want to separate out our customers so our first thought was to create a different database for each customer. Then someone mentioned doing it by using schemas. 1. If a lock escalates, will it attempt to lock the schema before it locks the whole database Hi, locks for SQL Statements are only es ...Show All

• Jeremy_B Error Msg 141 on Bulk Insert

  I've got the following SP to automatically insert all files in a directory into the database: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE Imp_Header_PO_sp @FilePath varchar ( 1000 ) = 'D:\EBT\Outbound\' , @WIPPath varchar ( 1000 ) = 'D:\EBT\Outbound\WIP' , @ArchivePath varchar ( 1000 ) = 'D:\EBT\Outbound\Archive' , @FileNameMask varchar ( 1000 ) = '*Header.tx ...Show All