Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | kamii47Constraint Violating Yak Guru
 
 
                                        353 Posts | 
                                            
                                            |  Posted - 2009-09-17 : 03:08:54 
 |  
                                            | I have generated script from an existing MS access DB.Create script works fineBut there is a alter script which i don't know why giving syntax errorPlease let me know what's wrong with thisALTER TABLE [MyTestTable1] DENY ZERO LENGTH [C1];Kamran ShahidSr. Software EngineerAssurety Consulting inc.(MCSD.Net,MCPD.net) |  |  
                                |  |  |  |