domingo, 22 de enero de 2017

Cambiar nombre a una base de datos SQL


Presionar F2 y cambiar nombre.

Posible error:


Solución:

Ejecutar script:
use master;
ALTER DATABASE [OLD_DB_NAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE [OLD_DB_NAME] MODIFY NAME = [NEW_DB_NAME]

ALTER DATABASE [NEW_DB_NAME]
SET MULTI_USER WITH ROLLBACK IMMEDIATE

Referencias:
http://stackoverflow.com/questions/16685269/error-on-renaming-database-in-sql-server-2008-r2

Néstor Mercedes

Author & Editor

Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.

0 comentarios:

Publicar un comentario