How to open LDF file of SQL2000
-
I have got a problem with modifing the tables of MDF because the LDF file cannot make a corresponding changes. I used SQL2000 manager to ouput a table of mydata(game database) to a xls file. Then I used Excel to make changes to it, since Excel is easy to manage a great number of entries. After having finished that, I converted xls file back to the table in mydata. Something went wrong, cuz I hadn't update the corresponding LDF file. Could someone give a solution? many thanks.
-
I have got a problem with modifing the tables of MDF because the LDF file cannot make a corresponding changes. I used SQL2000 manager to ouput a table of mydata(game database) to a xls file. Then I used Excel to make changes to it, since Excel is easy to manage a great number of entries. After having finished that, I converted xls file back to the table in mydata. Something went wrong, cuz I hadn't update the corresponding LDF file. Could someone give a solution? many thanks.
NEVER trust Excel to handle data output. Reports are okay, but Microsoft knows all and since you really do not want that 16 digit account number to be text, they make it scientific notation dropping the last few digits in the process. That leading zero is defanintly not needed. 1.1 well that should really be 1.10000000102. These are NOT a rant they are fact (except the value shown for the decimal). Get a good text editor. I believe NotePad++ will do it and there are several pay to use packages that say they handle large files (I use VEDIT).
-
I have got a problem with modifing the tables of MDF because the LDF file cannot make a corresponding changes. I used SQL2000 manager to ouput a table of mydata(game database) to a xls file. Then I used Excel to make changes to it, since Excel is easy to manage a great number of entries. After having finished that, I converted xls file back to the table in mydata. Something went wrong, cuz I hadn't update the corresponding LDF file. Could someone give a solution? many thanks.