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 , Thank you for your responses but I am not looking at configuring the SAN, we need to assume that the SAN has been configured in an optimized manner. Data, log and tempdb would be on the same SAN. This is a client environment and I have no way to change that. What I am looking for is how...

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

In addition to the previous response remeber that when you schedule a DTS job the DTS package is run by the account/login that also starts the MS SQL AGENT. That account make not have the necessary privs on files, folders or shares that your account has.

Hi, I am not sure if you are using MS SQL or Oracle but MS SQL has ni MINUS set operator. Another reason you might have incorrect results is because you might have nulls in either C1 or C2 so you can use the isnull function to replace nulls with spaces and this should give you the desired...

The reason for having it on a separate box would be so that there is no performance impact on users when data is being loaded to the data warehouse, Also better performance would be delivered when users are performing drill down analysis from the cube to the datawarehouse fact tables That is...

Thank you, I have one more question. Are there any steps I need to follow up on after the install such as migrating the repository, setting any additional config settings etc ?

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 To answer a few questions: The database processing does not error and the process does run for 15 miniutes. There is no error with the VB code as I am able to step thru the code in debug mode. Back to my question is there any alternative to Screen.MousePointer = vbHourglass to change the...

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

Thank you very much synapsevampire. That sugestion does work :-)

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

Hi thanks for your reply, I cannot use the copy/paste method as the servers are not visible to each other. I archive and restore sounds good but we want to move just one cube at a time not the entire repository. I would still like to know how to create and restore an archive as I don't know...