Search results for query: *

I have a field 'FirstName' that is 9 characters long. Some firstnames take all 9 characters and some do not take all the characters and have the middle initial. I want to strip the middle inital where it exist and where it does not exist skip and move on to the next. I used the folowing to...

I never used OLAP before. I am now working at a company where a programer created the cubes but he is no longer here. We want to upgrade the server from NT to 2000 and olap with anaylsis server. I have searched and not found any articles that clearly state the differences between OLAP and...

Does anyone know how the unload file is generated. For example we have a 24 GB database and during the unload the files are segmented into 2GB, my question is does anyone know what order the data is being pulled? Any help is greatly appreciated.[2thumbsup]

Hello All, I have been assigned the task to try and find out how to backup OLAP Cubes. I found how to backup to a tape but what I am looking for is the T-sql syntax. I need to test a backup and restore of a cube. We have several cubes on our server that no one knows who they are for. I...

I was wondering if anyone could give me a suggestion on what type of software I can use to reverse engineer a SQLBase database version 7.5.1. Any help is appreciated. [jester]

I have setup a database maintenance machine and running the mainteance via a script that is scheduled. However, the script keeps failing stating 'Invalid Cursor'. The funny thing is I can run it manually via sqltalk on the same machine. Has anyone seen this error and could you give me a...

Hello, I have been assigned a task to take log files from the web server that have been converted using a program called preplog.exe that Microsoft gives gives when you are trying to analyize the log files. It apparently converts the logs into a text file that you should be able to bulk...

I am very new to sql. I have a programmer who has a database with a table that has 1 primary key and 4 foreign keys. He wants to make sure that if a field is deleted that an error comes up. However, I was under the impression that a table should only have one primary key and one foreign key...

I am new to the realm of MSSQL 7.0 databases and the dts package. I have a data analyst who has an NT box the nt box has service pack 6 for NT, it has sp1,2 for MSSQL 7.0 and for olap sp1,2 &3. When he tries to create a dts package he gets the following error: DTS Designer Error: Could not...

I cannot find any documentation on this error code. I would appreciate any help on resolving this error.