title: Error renaming a temporary table
body: <p>Is it possible to rename a temporary table?</p>
  
  <pre><code>create table #t (id integer);
  execute tempdb.sys.sp_rename '#t', '#s';
  
  An invalid parameter or option was specified for procedure 'sys.sp_rename'
  </code></pre>
  
  <p>The proposed solution by @Michel, inserting into another temp table and dropping the original, works but I guess how expensive it is.</p>