Database growth excessive when changing varchar length from 50 to 100.

Hi all,

I'm trying to get an understanding of a serious problem I have with a large DB in production. This is going to be obvious to someone (everyone probably) <bg>

I have a table which consists of numerous varchars and ints but also a Text type field. This table resides in a SQL 2000 Database. This DB currently has a data file size of 16Gb and a Transaction Log size of 17Gb. When I edit the table and increase the size of a Varchar field from 50 to 100 these files grow to more than double their size!

Why is this happening and how can I prevent this?

TIA

NozFx

Hi all,

Ok made two huge mistakes here. One I have large text data along side other fields that when changes are made the structure changes dramatically. Secondly I have full transaction logging in which all changes are logged. Going to have to make sure I learn my lessons here. Got all the sizes down now but I needed double to do that.

NozFx

sql

Database Field showing as zero in report footer but works in group footer

I'm fairly new to crystal so there may be an obvious solution but I just can't find it. So any help what-so-ever would be excellent and much appreciated...

Problem:

Database field shows correct value and works in formulas properly in group footer.
In Report footer this same database field shows as zero and therefore other formulas in the report footer do not calculate correctly.

Any solutions?Please. Any help would be greatly appreciated. I'm kind of in a time crunch.

I'm not sure why a database field would show the value in the group footer and come up zero in the report footer.

Any ideas??|||Sorry, don't know why either - the report footer always shows the final database record for me!
I have read of other people having this problem, and I believe that assigning the fiele to a shared variable has allowed the value to be used.|||I gave it a variable and now it works. How weird is that?!

Thanks for your help!sql

Database Engine from One Computer to Another

As an obvious novice, I am hoping the answer to this will be simple. I have two computers with SQL 2005 installed. One computer is used for development and the other will be used for the application. I would love to transfer the database from the development computer to the application compute. By the way, these computers are NOT networked and are miles apart. I did a ClickOnce for deployment but must have missed something because of the SQL 2005 error when trying to run the application on the application computer. Does difference in computer name, connection string factor into this?

Like I said, I'm new to all of this and any help would be appreciated.

Thanks

Hi,

I don′t really understand your situation. Transfering the database can be either done by scripts, with deploying a blank database on the remote server or backing up the original database and restoring it to the destination. If you have restored the database on the remote server it can be reached within a common connectionstring like those ones which can be found on http://www.connectionstrings.com

Don't really know if that answers your problem, if not don't hesitate to come back again.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de