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 |  
                                    | MondeoConstraint Violating Yak Guru
 
 
                                        287 Posts | 
                                            
                                            |  Posted - 2009-09-29 : 19:22:57 
 |  
                                            | I have the same application running on 2 servers, when an event fires on either one I want to increment an int field in a database table.What is the best way to do this without any risk of 1 click being missed?Thanks |  |  
                                    | visakh16Very Important crosS Applying yaK Herder
 
 
                                    52326 Posts | 
                                        
                                          |  Posted - 2009-09-30 : 00:29:39 
 |  
                                          | if you want autoincrement, you can make it an identity column |  
                                          |  |  |  
                                |  |  |  |