SQLblog.com - The SQL Server blog spot on the web
Geek City: Changing How To Change Your Database Properties — ALTER DATABASE
(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtype , sp_droptype , sp_addlogin and sp_droplogin . For changing certain database properties, we had sp_changedbowner and sp_dbcmptlevel, to name a few. Gradually, Microsoft has started replacing these procedures with the more generic DDL commands ADD,...(read more)
No comments:
Post a Comment