I set a record size to 100 characters in a SQL 6.5 table. I now need to
increase the size. What is the best/easiest way to accomplish this.
Thank you in advance.
David M. Gondek
>Thank you in advance.
>David M. Gondek
Mikael Wedham, Sweden
Please! No mail unless I ask for it.
>>I set a record size to 100 characters in a SQL 6.5 table. I now need to
>>increase the size. What is the best/easiest way to accomplish this.
>>Thank you in advance.
>>David M. Gondek
you will have to rename the table...
create a new table (with the old name) changing the column that you want..
insert into newtable select * from oldtable...
you will also have to
1. recreate the indexes, views, etc.
2. drop and recreate all of the sp's, and triggers.
3. be sure to re-apply all permissions...
It is kind of a pain in sql 6.5, but you can do it... Third pary tools (like
Embarcadero's DBArtisan) also make this quite easy.... Sql 7.0 also offers
better support for this kind of thing.
Wayne Snyder MCSE, MCT, SQL Server MVP
IKON Technology Services, C*te, NC Education
(Please respond to the newsgroup.)
I am really bad at databases and VB5...
All I want to do is to add or remove a record from the current recordset.
The code "Data1.Recordset.AddNew" adds an empty record to the recordset...
but I'm not sure how to change what record is to be entered!
Please help. Thanks!