From: reb01501@NOSPAMyahoo.com   
      
   rja.carnegie@gmail.com wrote:   
   >   
   > I'm also not sure what happens if the table names are these:   
   >   
   > N'[BO-Stud15].[year2011].[ExpectedCostcentre]'   
   > N'[BO-Stud15].[year2012].[ExpectedCostcentre]'   
   > N'[BO-Stud15].[year2013].[ExpectedCostcentre]'   
   >   
   > Can I then use the same primary key name on each of these tables?   
   >   
   Oh wait. I think I found the question :)   
   The answer is: object names within a database need to be unique within that   
   database. Object names can be duplicated in separate databases. This is   
   something you could easily have tested on your own ...   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)