Search results for query: *

I have a huge datawarehouse thing that is composed by an enterprise side and a so-called federated side. The FDW is, of course, on a SQL2000 server. Now: in this FDW there's a db with all the dimensions and other DBs with the facts. The DIMs are viewed in every fact-DB so that our reporting tool...

Has someone ever realized BO universes with these two DBs as RDBMS? I cannot believe i can't still find anyone who has connected BO to IBM DB2/OS390 and SQL2000!! Thanks a lot, bye. Averno, Italy.

Hi, this is my situation: we've just completed the TEST development of our datamart databases on a Compaq 8000. Now is time to migrate ALL the "datamart" (3 DBs) with ALL of the objects (db, sp, diagrams, roles, rules, ecc..) to the PRODUCTION hw (compaq 8500, SQL7). My question is: is...

I need to manage the number of rows affected by a query. If I run this script on my database: SELECT COUNT(*) FROM TABLE_NAME WHERE TABLE_NAME.FLAG = 'I' AND NOT EXISTS ( SELECT * FROM ERR_TABLE_NAME WHERE ERR_TABLE_NAME.FIELD_1 = TABLE_NAME.FIELD_1 AND...

Running this query: INSERT INTO FACT_AGGR_IMP_1 SELECT TOP 110000 * FROM FACT_AGGR_IMP on my server (compaq 8000 4 cpu 1 GB RAM) takes 29 seconds, running THE SAME query with 120.000 instead of 110.000 takes 3mins14secs, almost 7 times more!! Who is the guilty? Is there a way to understand...

I tried to convert an access97 database into sql70, but, after the conversion, all the relations got lost. Is there a way to follow to COMPLETELY convert the DB (tables and diagram/relations)?|-I Thanks a lot, bye. Averno, Italy.

I tried to convert an access97 database into sql70, but, after the conversion, all the relations got lost. Is there a way to follow to COMPLETELY convert the DB (tables and diagram/relations)?|-I Thanks a lot, bye. Averno, Italy.

The std master installation places the SHDATA directory under the BUSINESSOBJECTS directory: Is it possible to select a different path for this directory SHDATA? Thanks a lot, bye. Averno, Italy.

After having trapped system errors with the @@errors variable, i find in the master.dbo.sysmassages this description: %ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls. The question is: is there a way to substitute that...