Error while renaming Database.

• Subhash-141882

  Ten Centuries

  Points: 1294

  More actions

  March 15, 2005 at 8:16 am

  #66588

  Hi All,

  When i'm trying to rename a database using sp_renamedb  Im getting the below mentioned error. (5030 is the error number in Books Online). Can any one please tell the reason and how to solve this.

  "The database could not be exclusively locked to perform the operation."

  Thanks,

  Subhash

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  March 15, 2005 at 8:23 am

  #547069

  You probably have one or more users in the database.

  Make sure that noone is using the database, then try again.

  sp_who2 is an easy way to see in which db's users currently are. (including yourself )

  /Kenneth