Archived Months
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server data warehouse > september 2003 > threads for september 8 - 14, 2003

Filter by week: 1 2 3 4 5

HELP!! SQL Server does not exist or access denied.
Posted by ChrisNet at 9/14/2003 10:17:56 PM
i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>


More fields in an Access Form
Posted by Annie at 9/12/2003 10:53:06 AM
Hi all, Unfortunately, there's a FLAT Database at my work place ( : ( )... It caused performance problem untill I created views for it. However, now, it happened ( I have no control over.. >_< another long story..) that the users wants to add 22 fields with Data Type bit to the FL...more >>

Data archive design question
Posted by Vagif Abilov at 9/10/2003 5:48:46 PM
We've come across the task of how store old data that are no longer in use. This can be temporary session codes, old user profile data etc. System is required to archive everything. We consider two mail alternatives: 1. Store both active and old information in the same database table, and have...more >>

Delete Records Without Logging
Posted by Erik Klein at 9/10/2003 6:32:46 AM
Does anyone know a way to delete records (4 million) and not have it write to the log file? I know in 2k we can turn on simple logging on the database but this is for a SQL 7 server. Thanks in advance, Erik Klein erik.klein@dfait-maeci.gc.ca...more >>

Error in connecting to Analysis Service
Posted by Miranda Kwan at 9/10/2003 12:26:50 AM
Users in the OLAP administrator group, except administrator, are not able to connect to the Analysis service after SP3 applied. The error shown as follow: Cannot connect to the repository. Analysis server: {server name} Error: Could not use ''; file already in use. Please assist to solv...more >>

using fact table in dimensions ?
Posted by Edmo at 9/9/2003 9:13:31 AM
hello, can I use fact table as one of the table in dimesion (snowflake schema)? the situation is: I've got invoice number in the level of the one sale line in fact table and a dimesion table with types of sale documents. I want to have hierarchy: DocGroup (comes from the dim table) -> DokKind...more >>

during scheduled backup system crashed & i got database suspect
Posted by elie chucrallah at 9/9/2003 2:03:32 AM
During scheduled backup job (dump database to disk) the system crashed & i got database suspect, and the previous backup file was deleted. Now i restored a 2 days old backup version of that database. I was wondering if dump database to disk with 'with init' option does not replace the old copy u...more >>

DW Design Question
Posted by Morgan at 9/8/2003 9:03:23 AM
Greetings, I am in the process of designing the logical/physical model for our DW and am curious as to what the best practice would be in our scenario. The scenario is we have approximately 4 years of transactions in a single table. Would it be best to leave all the data in one fact table and ...more >>



Offline Cubes and BI Accelerator
Posted by jollero at 9/8/2003 7:12:47 AM
Has anyone encountered creating offline cubes using microsoft excel? When we to create ours, we keep getting the error, "Data source provider error". We've been able to create offline cubes from datawarehouse projects that was not created using BI Accelerator. Our Facts: 1. Most of our cubes ha...more >>


DevelopmentNow Blog