title: Renaming of Table
body: <p>I am using sp_rename to switch table name , below is my query</p>
  
  <pre><code>exec sp_rename 'dbo.People_Daily' , 'TEMP'
  exec sp_rename 'dbo.People_Future', 'People_Daily'
  exec sp_rename 'TEMP',   'dbo.People_Future'
  </code></pre>
  
  <p>My questions is, what if I execute the same query in parallel with different table name,since im using TEMP word in both query, is there a possiblity that the TEMP in People will be used by Address?, what should I do to avoid this, is there any auto generated word to replace TEMP?  </p>
  
  <pre><code>exec sp_rename 'dbo.Address_Daily' , 'TEMP'
  exec sp_rename 'dbo.Addresse_Future', 'Address_Daily'
  exec sp_rename 'TEMP',   'dbo.Address_Future'
  </code></pre>
  
  <p>Thanks!!!</p>