I'm moving some data from AS400 DB2 to SQL Server and run
into date conversion problems.
My date from DB2 is numeric 8 characters eg "20031231".
How can I convert it to either datetime or smalldatetime

I recently heard a rumour that MS is going to focus less on MOLAP functionality in Yukon (or post Yukon releases) and focus more on supporting traditional ROLAP star-schemas in the RDBMS (<> MDDBMS)
Is this just hearsay or are there any facts availiable to shed some light on this ...

I m trying to use BCP utility to upload a huge text file.
As per microsoft documentation, -R is used to specify the
regional settings. My computer (client) and the sql server
(running in a network machine) has dd/mm/yyyy as the

I need to write a script that will remove any constraints and triggers from
any table in a specified database.
My problem is that i don't know where are stored in the system tables the
constraints and relations...  I've been told that once this would be found,

I am working on a application which has a table with 100 million
records.
A background process keeps inserting 5 rows per second into this
table.

Since two days I get an error when I try to build a dimension. Analysis
Manager stops working (it hangs) and I have to kill the process and restart
Analysis Services.
The temporary files of the dimension TEST

I am new in building cube & fact table.
I was trying to run a DTS package that created by someone else and when it
reached "Rebuild Dimension process".  It gave me this error message.
**** Error ****

Hi Group,
Sorry if this is in the wrong group .........
I was hoping someone might be able to help out a newbie out?
I`ve installed SQL 2000 on a machine now im stuck. I`ve managed to find

i really dont know how to design the table, would you please give me some
suggestion?
their have server user, and there have some customer record, said username,
password, email and address

Date:  Wednesday, November 19, 2003
Time: 10-11 AM Pacific Time (11-12 PM MT, 12-1 PM CT, 1-2 PM ET, 18:00-19:00
GMT)
Join experts from Microsoft and Aspirity as we discuss topics ranging from

How do I know where the cubes are sitting on the file
system?
Also, how do I change the location of the cubes? I'm
running out of disk on one drive (processing fails because

I have a simple customer dimension.  Some of the customers
are grouped together, but none of me data sources have the
groupings, and there is only one user that needs the
measures aggregated at the parent level.  Is there an MDX

I have read(1) that StrToArray can only handle 1,048,576  items.
Is this still the case
I need to call an external function and it is not guaranteed that the set will always conform
1. (Article) BASIC STATISTICAL CALCULATIONS IN MDX AND ANALYSIS SERVICES By George Spoffor

Microsoft User
this is the latest version of security update, the
"July 1999, Cumulative Patch" update which resolves
all known security vulnerabilities affecting

Dear all,
I need to map the procedure and table dependecies in our
data warehouse running on SQL2K.
The system is partitioned in 3 databases (Staging +