Wednesday, 19 November 2014

Can not alter table tsql




If you find the following does not work

Alter table Table_name modify COLUMN  column_name  varchar(101);

Then try

Alter table Table_name Alter COLUMN  column_name  varchar(101);

This works on sql server 2005


Related
 
Cannot Alter Table Being Used For Replication


-
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...

  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • Emergencies go bag(s)
      Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...