Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Best method to add a column to DB		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Astralis
Senior Member

USA
1218 Posts
Posted - 25 April 2008 :  15:56:43  Show Profile  Send Astralis a Yahoo! Message  Reply with Quote
I need to add a column with a default integer into the TOPIC and REPLY tables. The REPLY table has 110k rows. The TOPIC table has 5k rows. What is the best method to do this without causing any problems?

I'm using MSSQL Server 2000 and usually access it to edit using Enterprise Manager.<

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 25 April 2008 :  17:17:36  Show Profile  Visit HuwR's Homepage  Reply with Quote
just add the column and set the default value shouldn't cause any problems doing it in enterprise manager<
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts
Posted - 25 April 2008 :  17:22:35  Show Profile  Send Astralis a Yahoo! Message  Reply with Quote
Good to hear. Thanks!<
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07