Hi pals,
I am trying to insert binary data in to  a field(data type:binary) of a
table. Facing a problem with inserting if the binary data contains
APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE  to end the data.

There are many points concerning the BI world that are very confused for me.
-> What is a relational DB ?
A relational DB is for example Oracle, SQLServer or mySQL isn\'t it ? So on
a relation DB, we can model an entity/association DB (especially for OLTP)

Is there any class(es) to create RDL file? I am creating something like that myself now, but Microsoft already somehow creates RDL files in Visual Studio. So, does Microsft exposes these classes to developers? I am sure they(casses) exist.
Thank you.
Victor

Is there a SQL function to get FileTime?
Filetime is a 64 bit number representing time(up to nano seconds) from
January 1, 1601 to what ever the time right now.
In C++/C# etc, you have functions to get his value or to convert file time

I'm new with data warehousing. Just wondering, do any of you know of a
free sample/example that would help me learn the ABC's of data
warehousing?
The SQL 2000 sample is only available with SQL Enterprise..

Just a little question... how could I document a cube?, i mean, for a Q&A
enviroment... Something like:
Cube Name: Sales
Fact Table: Table Nable, Granularity, etc.

When populating a table with a column of TEXT datatype, an error
message was shown, indicating that the data is too large for the
specified buffer size.  How we I change the buffer size from the SQL
Server Enterprise Manager?

Is there a simple answer to this simple question?
How to import fixed-width text file?
I know the width of the columns but there are so many that I don't want
redefine them. I have already a table build for that data with the necessary

I created a cube for Inventory valuation.
Every monthend a static Inventory valuation of every item will be put in the
cubes.
1. I don't want to aggregate the value across the months;

I am using one cubes for my sales analysis.
When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
create error with something related to fail to create index.
I didn't change the cube design.

How do I access AS database meta data (cubes + properties) from an
asp.net page?
Hans

Currently runningSQL 2000 Standard
I have a parent - child dimesion called Employee where the
I have a member key of called Employee_ID which has an int
from 1 to 5, and a Parent Key which maps to the

i'm facing some difficulties in trying to process a 3 dimensional cube.
Everytime i try to process this cube it'll complain that "A member with key
"(something)" was found in the fact table but not found in the level
(dimension level's name) of the dimension (dimension name)

My network administrator set up all of the server backups using a Veritas
client to back up my sql server 2000 database. When I looked at the database
today after a couple of months with no sql server backup it shows the last
backup date as September 2004, and the size is over 20 GB ...

tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start.  Verify that
you have sufficient privileges to start system services."