Search results for query: *

Hi, The default install of MS Analysis services would create the following folder and all databases (dimensions, cubes) will be created in this folder. C:\Program Files\Microsoft Analysis Services\Data Is there anyway to change this so that these data files are stored in a different location...

Hi, When a user runs the DBCC CHECKDB command you may get X consistency errors etc.. Can anyone explain an example of a DB consistency error please, (I tried to google it with no success ) Thanks U

Hi, The Analysis services 2000 books online, under the MDX section has a sample database with dimensions, route, source, time and measures packages and last. Does anyone know where I may download this sample database ? Thank you -u-

Hi I have a setup where my Analysis server box (server a) is different from the Database server box (server b) I want to process a cube on Server A using the Analysis Services processing DTS task on Server B. However when I create a new package with the task on Server B, it only shows Server...

Hi All, I need some help with DTS mail task. All I have is an SMTP server name and an email address. Is there a way to send email from a DTS with just the SMTP server and the email address. The mail task requires a MAPI client, what is an example of a MAPI client ? It also needs a profile...

Hi I am setting up a MS SQL 2000 database that will reside on SAN the eventual size of the database will be 200 GB I need some advice on the DB create Which of the foll is advisable: a) Create an initial data file that is maybe 50 GB and let it grow by 10% b)Create a 200 GB data file...

Hi, I am writing 15-20 dts packages that load data from tab delimited text files into MS SQL tables. If for some reason the source directory changes I would need to change all of these DTS packages. Is there a way that I can set the source directory of the "Text File Source" connection so...

Hi, I need to install MS Analysis Services on a box other than the database server (MS SQL 2000. Can anyone provide any guidence on how to do this ? Thank you -U

Hi, I have a VB6 application where I am calling a SQL Server 2000 stored procedure. When I execute the stored procedure using query analyzer it works fine, however when I executed from the VB application using ADO it would execute and fail somewhere. I removed all my print statements and set...

Hi, I have a VB6 application where I am trying to change the cursor to an Hourglass while the application is doing some database processing I used the following: Screen.MousePointer = vbHourglass .. Data base processing code Screen.MousePointer = vbDefault However the mouse pointer remains...

I need to create a report with approx 40 columns in crystal and then export it to excel. If I have 7 or 8 columns this works fine because my printer supports that page size (8.5x11) however I cannot create a "wide report" even if all I wanted to do is export it to excel If you have any ideas...

Admins. I have an extremely urgent situation I need your help with: I have inhereted a sun e450 system where the root disk is 18GB with 2 slices / - 16 gb and /swap 2 gb /export /usr /opt are all subdirectories of the / partition. How can resize / partition to be 4 Gb and /export = 4 GB...

Is their a way to migrate OLAP cubes between environments such as from development to production. This is possible if you can attach both OLAP servers and the perform a copy paste. However if these environments are totally detatched is there some way to copy the cube Thanks -u-

DBA's Our database has been running for about 4 months and the alert_<sid>.ora file has now grown to 40 MB. Is it advisable to truncate this file. If yes, what is the best way to do this without bringing down the database. Any help appreciated. Thanks Umesh

DBA's Is there a way to spool the output of multiple queries to a spool file without the query being sent to the spool file. I have tried set feedback off set echo off However the query still gets sent to the spool file e.g sql> set feedback off; sql> set echo off; sql> spool c:\test.out...

DBA's I have created a trigger on update, insert and delete on a table to insert a row into an audit table. When in sql plus and I perform any insert,update and delete the trigger fires as required. When the update is performed from a web based application the trigger does not fire. Has...

DBA's I get the following error when I try to do an import. I reran catexp.sql and utlrp.sql as sys however I still get the same error. I am running Oracle 8i (8.1.7.4) on solaris Any help appreciated. Thanks -u- IMP-00017: following statement failed with ORACLE error 4068: &quot;BEGIN...

DBA's I have come across the following problem and would like to know if you have a solution for it: When I compile the following stored procedure: (The procedure does nothing but demonstrate the situation and is run in the SCOTT schema) create or replace procedure test1 as cursor c0 is...

Hi, I am trying to compute a sum of a certain column in sql plus however the sum line is not appearing I have done the following: clear computes compute sum of amount on report but when I do the same on the scott/tiger schema the compute works fine. Is there something that I am perhaps...

Admins, I am trying to compress a 10 GB file into 10 1 GB files using zip or tar on a Solaris 8 machine, then I want to ftp these files and uncompress them onto another Solaris 8 machine. If you have done something similar, please let me know how this can be done. Thanks Umeman