title: How to rename database in multi-user mode
body: <p>I am working on SQL SERVER 2008 &amp; 2008 R2.
  How can I rename a database in multi-user mode?
  I am using sp_rename but it returns this error:</p>
  
  <blockquote>
    <p>Msg 15225, Level 11, State 1, Procedure sp_rename, Line 338</p>
  </blockquote>