Recent content by pto

Thanks, I will muck with it and see if I can get the middle initial. [thumbsup]

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

Thanks for the info. I already resolved. Just for your info.[colorface]

If your getting an error with the books online then reinstall sqlserver 7.0. It's not that hard to create a database. However, I would start with SQL2000, it is more user friendly than 7.0 also SQL2000 is fast over taking the older version.

Thanks for the tip. I also contacted Microsoft as this is a high priorty for my company. It turns out you install the addins for olap 7.0, archive the database and restore in Analysis Services or onto another olap 7.0 that has the addins.

The data you were importing was it from a compressed drive? A freaky thing happened to me. I just set up a new report server ran a replication process that uses dts and they errored when we looked at the drives someone had compressed the drives. We had to decompress all three drives which...

Thank you for the information. I am using the Microsoft's OLAP Manager. The problem is the server that has the cubes is offline. Unlike regular databases which I know how to move and restore to another server no problem. When it comes to these cubes I am lost. So if I currently have MS SQL...

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

Ok, I have called Microsoft support becuase I could not get any information that would give me the answer. I found out the following: If you are running the desktop version of SQLServer there is a database limitation of 2048 MB. No matter what you do you cannot go beyond this amount...

I am having the exact same problem and I too have yet to find an answer that makes sense.[sadeyes]

Thanks SonOfEmidec1100 I was not sure you could do that. I will try.[thumbsup2]

Yeah I have seen that script and the example shows moving both the database and the transaction log. The question is how do you move the transaction logs to a different drive not the database. Or does it mean that you would still have to detach the database and the move the transaction log...

You state that you tried an unload, does that mean you performed the unload of the table and then loaded the table back in. You have to load the table back inorder to get data.

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]

Tried that however it failed at the restore. It took less than a minute to backup and was taking upto 2 hours to restore. Thanks for the help.