Change Tables Field Size ie. varchar(50) to varchar(100) - SQL Server 2000

I'm pretty deep into a web application I'm building for my current employer. It's about 90% done, 3 weeks of work. Because of this I do not want to change the setup of the project.

I would ideally like to be able to change the size of fields in a table. Such as, varchar(50) to varchar(100). I'm just wondering if the resizing is possible.

Another problem I am having is renaming a table. I've seen the syntax for it but everytime I try it doesn't work.

My code:

if not form_in_new_name = "" then
sSQL = "RENAME " & form_in_name & "_table TO " & form_in_new_name & "_table ;"
Set rs2 = cn.Execute(sSQL)
Set rs2 = Nothing

Thanks for the help in advance!

1) Can't you just change the size in Enterprise Manager?
2) You need to use the alter table command, like this


BTW, In the future please post you questions in the proper forum. The Code Bank is for sample code only, not for questions.