Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Averno

    Zero Admin BO & InfoView

    You need to install WebIntelligence server. Infoview is only the name of the home page... thanking B.O. for this mess. Thanks a lot, bye. Averno, Italy.
  2. Averno

    Cross-reference in SQL2000.

    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...
  3. Averno

    BO connection with IBM DB2/OS390 and SQL2000

    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.
  4. Averno

    Create a new button on BO toolbar

    I subscribe the RMALSICH reply, you need the BO SDK. Thanks a lot, bye. Averno, Italy.
  5. Averno

    Complete DB migration in SQL7

    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...
  6. Averno

    BO Documents

    www.businessobjects.com .... of course!::-) Thanks a lot, bye. Averno, Italy.
  7. Averno

    Storing results into variables.

    Just to add I already knew the @@rowcount, but, as tlbroadbent said, in my case it would contain 1, not 4. Thanks to both Andel and tlbroadbent for helping. (the last suggestion worked!!) Thanks a lot, bye. Averno, Italy.
  8. Averno

    Storing results into variables.

    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...
  9. Averno

    Query performance?!

    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...
  10. Averno

    Converting from ACCESS97 to MSSQL70

    OK, so: are you re-generating all the table relations "by-hand"? B-( Thanks a lot, bye. Averno, Italy.
  11. Averno

    Scaling from A97 to SQL70

    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.
  12. Averno

    Converting from ACCESS97 to MSSQL70

    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.
  13. Averno

    BO master installation.

    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.
  14. Averno

    Help: error TRAPPING with sysmassages

    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...

Part and Inventory Search

Back
Top