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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|