Answer Questions

• Bruni Error: Attribute key cannot be found

  Helo, I have the following problem I have one fact-table in my cube And I have one dimension table When I process the cube I get the following error: "Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306." I understand the error, and I know why I get the error, but how can I solve the error In the fact-table there is a record with key 306, but this key is not fo ...Show All

• CharlestonSW.com AS2005... Using Attribute Relationships

  I assume defining attribute relationships can be advantageous for performance. However, I don't quite understand them. I know by default, the dimension is created with all attributes having an attribute relationship under the key -- with all having a cardnality of Many. My Customer dimension points to the following named query: SELECT customer_key, customer_id, customer_name, city, post_code, region_code, country_code FROM Customer C LEFT OUTER ...Show All

• 7racer Automate Database Project

  We use seperate database instances for development, qa, ua, and production with multiple databases in each environment.  So, I'm looking for a way to automate the database changes to these different environments. After creating a database project with change scripts and database references, I can't seem to find a way to automate these changes out to a server/environment.  We're currently using SQL 2000 + 2005, Visual Studio ...Show All

• Parthasarathi restricting the amount of data getting into a cube

  i have a cube with a lot of data. there is so much data that when a report is run on the cube it takes a substantial amount of time to build the report. the cube contains data for the past 5 years. i want to limit the amount of data in the cube to just the last 1 year, so that when i process the cube, it only pulls in the last year of data. how do i go about doing this Im using sql server 2000 database. In you ...Show All

• MSTIDragon Is there a as400/db2 native provider to extract data?

  Is there a as400/db2 native provider to extract data Ok. I downloaded and installed the trial version of the Host Integration Server. In HIS, I can establish a connection to the AS400 and submit a simple query which works fine. However, when I create a OleDb data source object in SSIS using the Microsoft Ole DB Provider for DB2 I get the error: Test Connection Failed because of an error in initializing the provider. The parameter is incor ...Show All

• Cuperman Error while restoring SQL7 data on SQL Express 2005

  Hi, I have backup of data from SQL Server 7.0 and now when i'm trying to restore it into SQL Express 2005, I'm getting following error...... -------------------- Msg 3154, Level 16, State 2, Line 1 The backup set holds a backup of a database other than the existing 'GOSLDW' database. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. -------------------- Here is SQL i'm using to restore database, RESTORE DATABASE ...Show All

• gardenspider Access rights...

  Hello, I want to restrict the database not to be accessed from anywhere except my webservice...I mean, my client applications or anyone else can not be able to access the database... How can I do this Thanks very much... Are you looking for something similar to what was discussed in the following thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=52094&SiteID=1 If not, can you explain what exact ...Show All

• Tim Thornton Generate documentation of tables and columns?

  Is this possible the tables has a field called description and so does the columns. I need to generate a data dictionary. You might want to consider SchemaToDoc ( http://www.schematodoc.com ). It creates Word or HTML output that documents primary keys, fields (datatype, size, nullable, defaults), indexes, check constraints, foreign keys, triggers, views, and stored procedures. It also has an interface that lets you annotate your tables an ...Show All

• Hamdy Ghanem132708 Registry to store configuration values ?

  I try to store a SSIS-configuration value in the registry. But it's failed. I get a warning, that the registry-key is not found. What is the syntax I have searched in BO,MSDN and  Google/Internet ==> nothing. There is no example.     The syntax of how to specify the name of the registry key is straightforward. See BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsq ...Show All

• Bread95432 Is there any way to show or hide the Document Map dynamically depend on parameters?

  hi, all I have a class report with class no as paramter. This parameter could be null. So, if users enter null, it will show all of them for all classes. Otherwise, it will only show the data for that class. So, what I am thinking about is, if the parameter is null, report shows all data, it will be very nice to show the Document Map on the left side. If users entered class no, then there is only one class in this report, no use to show or use t ...Show All

• JimDuncan error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20 ...Show All

• 96RT10 Oracle 9i -> SQL Server 2005: Snapshot agent aborts suddenly uninterrupted

  Hi - I hope some of you can help me with this problem. I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below. Message 2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied) 2006-06-14 0 ...Show All

• Jeffrey Liu Puzzled by concurrent update

  I have a puzzle in my mind here. I will thank anyone who can solve my puzzle. I am not familiar with SQL and its theories behind, so please bear with me if I am asking a stupid newbie question. My puzzle is generally a problem of generating sequence numbers. The following SQL is only a stripped down version - it fetches the max number, add 1 to it and updates the table with the new number. DECLARE @max int SELECT @max = MAX(next_numb ...Show All

• Reyad Debugging SP On server from workstation using Query Analyzer

  Hai .....,          I 'm able to debug a Stored Procedure directly on the server, but I 'm not able to debug the same stored procedure from my machine. What should i do in order to debug the stored procedures  on the server from my workstation.           (I can debug the stored procedures of my local sql server) Please take a look at t ...Show All

• rfinlay Roll back to Data

  Hi Guys I have unfortunatlly executed update query. My problem is have executed update command instead of Insert command. can i roll back again but in Oracle is possible SQL>Update Command SQL>Rollbank this is ORACLE. How can i execut it. In SQL SERVER. advanced Thanks Krishna In SQL Srever implicit transactions are turned off, so unfortunately if you want to recover you need to res ...Show All