0

I am using help of SqlServer.Management.Smo to rename an attached MS-SQL database.

Dim db As New Database = ActiveSQLServer.Databases(OLD_NAME)
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " SET SINGLE_USER WITH ROLLBACK IMMEDIATE")
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " MODIFY NAME = " & NEW_NAME)

The problem is that after renaming the database is set as a Single User.

So what am i doing wrong?

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
OrElse
  • 9,709
  • 39
  • 140
  • 253

1 Answers1

2

Your 2nd statement is setting it to single user.

ozczecho
  • 8,649
  • 8
  • 36
  • 42