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)

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • 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...
  • Restore Windows App after a Crash.
    If you have a situation that requires an application to always be up then try   Restart program after a crash downloadable from  https://w-s...