2010年12月29日 星期三

SQL Server: Enable database service broker

Declare @MyDatabase Varchar(20)
Declare @MySQL Varchar(100)
declare MyCursor Cursor for SELECT RTRIM(name) DatabaseName
from master..sysdatabases
where status not in (512, 528)
and dbid > 4
Open MyCursor

Fetch next from MyCursor into @MyDatabase

While @@FETCH_STATUS >= 0
Begin
--Set @MySQL = 'ALTER DATABASE [' + @MyDatabase + '] SET ENABLE_BROKER WITH NO_WAIT' -- Enable Service Broker
Set @MySQL = 'ALTER DATABASE [' + @MyDatabase + '] SET PAGE_VERIFY CHECKSUM WITH NO_WAIT' -- Change Page_Verify
--print (@MySQL)
exec(@MySQL)
Fetch next from MyCursor into @MyDatabase
End

Close MyCursor
Deallocate MyCursor

沒有留言: